The Excel SUM function returns the sum of the values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments.

Purpose 

Add numbers together

Return value 

The sum of values supplied.

Syntax 

=SUM (number1, [number2], [number3], …)

Arguments 

  • number1 – The first value to sum.
  • number2 – [optional] The second value to sum.
  • number3 – [optional] The third value to sum.
  • The 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.
  • The SUM function takes multiple arguments in the form number1number2number3, etc. up to 255 total. Arguments can be a hardcoded constant, a cell reference, or a range. All numbers in the arguments provided are summed. The SUM function automatically ignores empty cells and text values, which makes SUM useful for summing cells that may contain text values.
  • The SUM function will sum hardcoded values and numbers that result from formulas. If you need to sum a range and ignore existing subtotals.
0
Would love your thoughts, please comment.x
()
x