# SUM Formula in excel with example ## 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 – Technology Sagar