The SUM function in Excel is the count function for a column or a row, although it is user-specific. Sum function is one of the most basic functions in Excel that upon learning about the function, users will learn immediately about the SUM function. The Sum function is very basic and to make sure it doesn’t take you too much time.
Syntax: = SUM(number1,[number2],…)
- number1: The first number you want to add. The number can be like 4, a cell reference like B6, or a cell range like B2:B8.
- number2-255: This is the second number you want to add. You can specify up to 255 numbers in this way.
Example: for 1 table of values
1.1 Syntax: =SUM(C2:C11)
Result:
1.2 Syntax: =SUM(C2:C3,C6:C8)
Result:
1.3 Syntax: = SUM(number1,[number2],…)
Result:
Hope this guide helped you. Good luck!
