So you want SUMIF formula.? - Examples of Excel sumif Formula

SUMIF Adds the cells specified by given set of conditions or criteria, using sumif formula you can give conditions to ads the cells that contain numbers,

Logically SUM formulas adds all the numbers in a range of cells , like wise SUMIF or SUMIFS adds the cells specified by given Conditions or criteria, the power of illustration lets have a look at few examples I have given below.

How to use SUM formulas

How to use SUMIF formulas

Example 1 : SUM Formula in Excel.

SUM( [sum_range] )

Below have an example to Adds all the numbers in the Table.

=SUM(C2:C11)

Sl.no	Sales Managers	Sales Rs
1	MURALI	245
2	OM PRAKASH	324
3	RENUKA	234
4	VARUN	543
5	RENUKA	345
6	VARUN	123
7	MURALI	321
8	VARUN	234
9	VARUN	543
10	MURALI	345
Total		=SUM(C2:C11)

Explanation: SUM function tells excel to add all the cells that contain numbers,

Example 2 : How to use SUMIF formulas

SUMIF( range, criteria, [sum_range] )

Using SUMIF Formula Adds the cells specified by given set of single conditions or criteria, Example i am going to SUM only Specified Name and their achievements.

Explanation : SUMIF Formula tells excel to sum only given criteria,