SUM Formula in excel with example

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.

ABCDEFG
1Student NameHindiEnglishTotalFORMULARESULT
2Ajay6655121= SUM (C2: E2)242
3Kajal5649105
4Poonam9689185
5Karan3978117
6Komal5569124

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.

ABCDEFG
1Student NameHindiEnglishFORMULARESULT
2Ajay6655= SUM (C2, D2)121
3Kajal5649105
4Poonam9689185
5Karan3978117
6Komal5569124

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

ABCDEFG
1Student NameHindiEnglishFORMULARESULT
2Ajay6655=SUM(C2,D2)/524.2
3Kajal5649105
4Poonam9689185
5Karan3978117
6Komal5569124

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

Leave a Reply

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