SUM Formula in Excel :-
You should be familiar with the first Excel function, which in addition performs basic arithmetic operations:
Excel’s SUM and Sumif formula is capable of totals with multiple conditions of any column and row.
Normal human can also do SUM with this formula.
SUM (number 1, [number 2],…)
= SUM (C2: E2) – Adds the values in cells C2 through E2.
| A | B | C | D | E | F | G |
| 1 | Student Name | Hindi | English | Total | FORMULA | RESULT |
| 2 | Ajay | 66 | 55 | 121 | = SUM (C2: E2) | 242 |
| 3 | Kajal | 56 | 49 | 105 | ||
| 4 | Poonam | 96 | 89 | 185 | ||
| 5 | Karan | 39 | 78 | 117 | ||
| 6 | Komal | 55 | 69 | 124 |
Meaning, your even formula must include at least 1 number, a reference to a cell, or a range of cells. for example:In the syntax of an Excel function, an argument enclosed in [square brackets] is optional, requiring other arguments.
= SUM (C2, D2) – Adds the values in cells C2 and D2.
| A | B | C | D | E | F | G |
| 1 | Student Name | Hindi | English | FORMULA | RESULT | |
| 2 | Ajay | 66 | 55 | = SUM (C2, D2) | 121 | |
| 3 | Kajal | 56 | 49 | 105 | ||
| 4 | Poonam | 96 | 89 | 185 | ||
| 5 | Karan | 39 | 78 | 117 | ||
| 6 | Komal | 55 | 69 | 124 |
If necessary, you can do further calculations within a single formula, for example, add values to cells through C2 through D2, and then divide the sum by 5:
= SUM (C2: D2) / 5
| A | B | C | D | E | F | G |
| 1 | Student Name | Hindi | English | FORMULA | RESULT | |
| 2 | Ajay | 66 | 55 | =SUM(C2,D2)/5 | 24.2 | |
| 3 | Kajal | 56 | 49 | 105 | ||
| 4 | Poonam | 96 | 89 | 185 | ||
| 5 | Karan | 39 | 78 | 117 | ||
| 6 | Komal | 55 | 69 | 124 |
Use the Sumif function with multiple conditions. Like I have expanded with the following example.
= Sumif (A2: A6, D2, B2: B6)
In your Excel worksheet, the formula might look like this:
Using SUM formulas in Exce
Note:
If you have any queries, About SUM Formula in excel with example please reach out to us through info@technologyogar.com
Have a good day 
