Sum excel formula

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

sum excel - Sum excel formula

1.1 Syntax: =SUM(C2:C11)

Result:

sum excel formula - Sum excel formula

1.2 Syntax: =SUM(C2:C3,C6:C8)

Result:

how to sum excel - Sum excel formula

1.3 Syntax: = SUM(number1,[number2],…)

Result:

sum excel formulas - Sum excel formula

Hope this guide helped you. Good luck!

READ:  What is countblank function in excel

Add a Comment

Your email address will not be published. Required fields are marked *