How to Use SUM Function Formula Using in Excel
SUM function Formula in Excel
The SUM function Formula is one of the Most Useful function,
Syntax: SUM(number1,[number2],...)
For example 1: Adding + Count
A B C (Result)
2111 25447 27558
Adds the value in cells A1 and B1. The result is 27558
Formula : =SUM(A1+B1)
=SUM(A1:B1)
For example 2: Deducting - Count
A B C (Result)
25447 2111 23336
Adds the value in cells A1 and B1. The result is 23336
Formula : =SUM(A1-B1)
Example 3
A B C (Result)
15 25 40
Formula =SUM(A2,A3)Adds the value in cells A1 and B1. The result is 40.
The SUM function Formula is one of the Most Useful function,
Syntax: SUM(number1,[number2],...)
For example 1: Adding + Count
A B C (Result)
2111 25447 27558
Adds the value in cells A1 and B1. The result is 27558
Formula : =SUM(A1+B1)
=SUM(A1:B1)
For example 2: Deducting - Count
A B C (Result)
25447 2111 23336
Adds the value in cells A1 and B1. The result is 23336
Formula : =SUM(A1-B1)
Example 3
A B C (Result)
15 25 40
Formula =SUM(A2,A3)Adds the value in cells A1 and B1. The result is 40.