The Excel SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments. Learn how to use the SUM function in Excel to sum a range of cells, an entire column or non-contiguous cells. Also, learn how to combine the SUM function with other Excel functions to create conditional sums, sum every nth row, sum the largest numbers and more. Learn how to use the SUM function in Excel to add values, cell references, or ranges. Find best practices, frequently asked questions, and related functions for more help. Home > Formulas > Math Trig > Sum Excel Sum Function Examples Examples show how to sum in Microsoft Excel , with a simple SUM function , or formulas that sum based on one or more criteria. First, for a quick overview, watch the video: 7 Ways to Sum in Excel . Next, scroll down for more Sum function videos, written steps, and free Excel workbooks.
