Skip to main content

The Excel Formula : SUMIF



Dear Friends.
We sometimes required to sum the value in the given range with certain criteria. It is very painful and time taking tasks if you have to do this manually, specially in a large database. So, here you will find the ways to get the output within seconds using the Excel inbuilt formulas.

ColumnC
ColumnD
ColumnE
Row3
Item
Date
Cost
Row4
Brakes
01-Jan-98
80
Row5
Tyres
10-May-98
25
Row6
Brakes
01-Feb-98
80
Row7
Service
01-Mar-98
150
Row8
Service
05-Jan-98
300
Row9
Window
01-Jun-98
50
Row10
Tyres
01-Apr-98
200
Row11
Tyres
01-Mar-98
100
Row12
Clutch
01-May-98
250
Total cost of all Brakes bought.

160
 =SUMIF(C4:C12,"Brakes",E4:E12)
Total cost of all Tyres bought.

325
 =SUMIF(C4:C12,"Tyres",E4:E12)
Total of items costing £100 or above.
1000
 =SUMIF(E4:E12,">=100")
Total of item typed in following cell.
service
450
 =SUMIF(C4:C12,E18,E4:E12)
What Does It Do ?






This function adds the value of items which match criteria set by the user.
Syntax







=SUMIF(RangeOfThingsToBeExamined,CriteriaToBeMatched,RangeOfValuesToTotal)
=SUMIF(C4:C12,"Brakes",E4:E12)
This examines the names of products in C4:C12.
It then identifies the entries for Brakes.
It then totals the respective figures in E4:E12
 =SUMIF(E4:E12,">=100")
This examines the values in E4:E12.
If the value is >=100 the value is added to the total.
Formatting






No special formatting is needed.
For any confusion, feel free to comment or mail at sharma.ctc@gmail.com
Labels:

Comments

  1. The Vat ConsultantDecember 28, 2021 at 7:59 PM

    Thanks for sharing this blog Very useful Post. Choose the best Vat registration Company in Dubai

    fta vat registration
    dubai vat registration

    ReplyDelete

Post a Comment

Popular posts from this blog

How to Calculate Detention of Vehicles considering the complex Date & Time in excel

Some times it is difficult to calculate some cases which deals with Date & Time and calculating the Detention charges is one of them. Please download the excel file (and do remember that it has been prepared on the basis the following basis.... which can be changed with the help of formulas) https://drive.google.com/file/d/0Bw1qNoQ8YzHZY3E5VVl1SUduWm8/view?usp=sharing
2 comments
Read more

Sai Sampurna Padhi - A Sweet Bubbly Girl fighting for her life at Cuttack

Hello Everyone, Today I want to share with you all about a girl named "Sai Sampurna Padhi" Some details of this girl: - Name                   : - Sai Sampurna Padhi Age                       : - 2.5 Years Residence           : - Bidanasi, Cuttack, Odisha Father's Name    : - Linku Padhi Mother's Name   : - Chandrika Mohapatra Father's Occupation    : - Auto Driver at Badambadi Bus Stand, Cuttack This girl is admitted to SCB Medical College because she is suffering from a very dangerous disease called "Blood Cancer" and as its at Stage-I doctors has prescribed to go for Bone Marrow transplant as soon as possible so that this can be cured. But the operation cost around 20-25 Lacks which they can't arrange. For the time being, every week she has need of blood, plasma, test & medicine which is less as it is a government ho...
Post a Comment
Read more

FAQs on Hydroponics

From last several weeks I was searching for this on web and now wanted to share it.. For those who do not know about "Hydroponics" , Let me tell you that this is an alternative to our conventional method of Farming.  Hydroponics in simple words is "the process of growing plants in sand, gravel, or liquid, with added nutrients but without soil." Why we need it because the urbanization is growing rapidly and the agriculture land along with manpower & labour is going down and rarely available. We have now to focus on some alternatives for our food. Here are the FAQ List which will help. What is Hydroponics? Hydroponics is the method of growing plants using a soilless media which could include a wide variety of examples like: gravel, peat, vermiculite Perlite, old rubber tires, rockwool, and expanded clay aggregates. The minerals that the plant needs are dissolved into the water which is then watered directly to the plants. So, in short instead of the pl...
Post a Comment
Read more