What does it do?

Sums the values in a range that meet a criteria that you specify

Formula breakdown:

=SUMIF(Range or Cells, Criteria, [Sum_Range])

What it means:

=SUMIF(Evaluate this Range/Cells, With this Criteria, [Optional Sum Range])

The SUMIF function is used widely amongst spreadsheet users as it is a simple Excel function.  It allows you to Sum the values in a range that meet a criteria that you specify.

So if you want to Sum a range of sales values that are above $3,000 then this is the best Excel function to use, as I explain below.


We want to get the sum of the sales amounts that are above $3000.

STEP 1: We need to enter the SUMIF function in a blank cell:


Sumif Formula


STEP 2: The SUMIF arguments:


What is your range that contains the source data?

Highlight the column that contains the sales data


Sumif Formula


Which records do you want to sum together?

Since we want to sum the amounts greater than 3000, then let’s type in >3000

=SUMIF(D15:D23, “>3000”)

Sumif Formula

Just like that, Excel has selectively found the values and summed them together!

Sumif Formula

How to Use the Sumif Formula in Excel



How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel


If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

How To Use INDEX-MATCH Formula   What does it do? Searches the row position of a value/text in one column (using the MATCH function) and returns the value/text in the same row position from another column to the left or right (using the INDEX function) Formula breakdown: =INDEX(array, MATCH...
Advanced SUMPRODUCT Function: Conditional Date If you want to find out the total sales for a particular month, then the SUMPRODUCT function is your answer.  You can create a criteria for a specific date range, a particular month or a year. In the example below I show you how to use the SUMPRODUCT function to sum up the tot...
Vlookup in Multiple Excel Sheets What does it do? Searches for a value in the first column of a table array and returns a value in the same row from another sheet´s column (to the right) in the table array. Formula breakdown: =VLOOKUP(lookup_value, table_array, col_index_num, ) What it means: =VLO...
Top Excel Formulas & Function Examples To Get... Below you will find many Excel formula examples for key functions like VLOOKUP, INDEX, MATCH, IF, SUMPRODUCT, AVERAGE, SUBTOTAL, OFFSET, LOOKUP, ROUND, COUNT, SUMIFS, ARRAY, FIND, TEXT, and many more. DATE & TIME DateDif EndOfMonth Time Weekday Workday ...