Excel Sumif

At several times we require calculating the total of our data tables based on some criteria.


Lets take an example:

Suppose we have a excel sheet that has the data of bills submitted by us and we calculating the aging of our bills from the date of submission. Only the bill submission date is older than 30 days then we forward the total start follow up by commercial department.

Here in above sheet we have the Bill submission date we subtract the submission date from today’s date in column E (Instead of entering today’s date in saperate column we can also subtract it directly from Today() function.

We put the Function

=Sumif(F2:F8,”>30”,C2:C8)

This function has three parts

=SUMIF(range,criteria,sum_range)



1. Range: first specify the range that we have to check if it matches to Criteria

2. Criteria: in this we provide the logical equation for the range we want to check

“=30” : Equals to 30

“>=30” : Grater then or equals to 30

“<=30” : Less then or equals to 30

“<30” : Less then 30

“<>30” : Not Equals to 30

>,< and = are the logical operator that can compare two values and can gives True or False results.

3. Sum_Range: in this part we specify range of which we have to take total.

If we ommit the last optional argument (sum_range) the SUMIF would sum all cells in the range F1:F8 which are greater than 30.