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 multipleargumentsin the formnumber1,number2,number3, etc.
up to 255 total.
Arguments can be a hardcoded constant, a cell reference, or arange.
All numbers in the arguments provided are summed.
The SUM function will sum hardcoded values and numbers that result from formulas.
If it’s crucial that you sum a range andignoreexisting subtotals, see theSUBTOTAL function.
Examples
Typically, the SUM function is used with ranges.
This can be useful insituations like this, where the first formula would otherwise throw an error.
Keyboard shortcut
Excel provides a keyboard shortcut toautomatically sum a range of cells above.
you’re free to see a demonstrationin this video.
Criteria can be applied to dates, numbers, and text.
SUMPRODUCT Function
The Excel SUMPRODUCT function multipliesrangesorarraystogether and returns the sum of products.
