SUMIF Formula MS Excel / How to use SUMIF Function in MS Excel.

Excel SUMIF Formula / SUMIF Function in Microsoft Excel / How to use SUMIF with Example in Excel Worksheet. SUMIF Formula Syntax Excel.

SUMIF is a very powerful formula in MS Excel. The use of SUMIF is very high in Companies. SUMIF is not so tough as it looks like. It's a very easy to use and important formula in Excel. Every Excel use should have knowledge about SUMIF Function. SUMIF Formula works in all MS Excel Versions like MS Office 2003, 2007, 2010 etc. Here we use SUMIF Formula with Example.

The SUM Formula in Excel simply count two or more values, but if an excel users wants the sum of a specific value in a specific range then SUMIF formula will be used. So, how to use SUMIF Formula / Function in Excel? Here we will learn SUMIF formula with example.

What is the Syntax of SUMIF and How to use SUMIF Formula in Excel Spreadsheet?

SUMIF Formula / Syntax:- =SUMIF(range, criteria, [sum_range]).

Range:- Cells range to be evaluated.

Criteria:- the condition or criteria which will be in the form of a number, expression, or text that defines which cells will be added.

sum_range:- the actual cells to sum.

SUMIF Sample Data

NOTE:- If sum_range ommited(leave blank) the cells in the range are used as sum_range.

SUMIF formula Example:-

Suppose we have a data of salespersons, target, total sale, and status for target achieve or not, now if

we have to calculate the total sale of those salespersons who had achieved their target then we will use SUMIF formula, below is SUMIF Example:-

Here we want to sum of the total sale for those salespersons who had completed their targets (those whose total sale value is greater than 600 rs.).

SUMIF Formula with Example

Here is the result for those salesperson who have completed for their targets 8199 rs (Sum of Total sales of the salesperson those who have total sale greater than 600).

In the above formula:-

Range is D2:D21

Criteria is D2

Sum_Range:-C2:C21