In this tutorial we will discuss, how to us SUM Function in Microsoft Excel. SUM Function is a most important and useful formula in Excel. Adds all the numbers in a range of cells.
How to Use SUM Function in Microsoft Excel with Examples
The SUM function can take up to 255 arguments.
B3 = First Value Cell Reference.
: Range of contiguous cells (for example, A1:C16)
B17 = Last Value Cell Reference.
The following formula, for example, returns the sum of the values in multiple ranges:
Horizontal range use in Sum Function:
The SUM function is versatile, but it’s also inconsistent when you use logical values (TRUE or FALSE). Logical values stored in cells are always treated as 0. But logical TRUE, when used as an argument in the SUM function, is treated as 1.