MS Excel SumIf Formula | Do Addition Based on a Condition

Learn the Sumif formula of MS Excel in the easiest way. The Excel Guru teaches how to calculate the the Sum of a range based on a specific criteria using the the Sumif formula .
The SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criteria (for example, is equal to 5000).

Parameters or Arguments of Sumif Formula

The range of cells that you want to apply the criteria against.
The criteria used to determine which cells to…

23 thoughts on “MS Excel SumIf Formula | Do Addition Based on a Condition

  1. Sir Mujhe Excel me bank reconciliation kaise karna padta he woh aap sikhao sir.. Mujhe 2 Bank statement se bank tally karni hai.. kaise samjh aye ki kon konsi entry leni baki he..plz sir

  2. Sir I'm practice this formula together video is open over my smart phone but when I'm type criteria number row from out of criteria range except type criteria name or select criteria row number from data
    Problem answer apper like 0 or #value

  3. सर नमस्कार मेरा प्रश्न था कि अगर जनवरी २००० से दिसम्बर २००० तक जोड़े तो जोड़ १२ महीने आय , और अगरअप्रैल २००० से दिसम्बर २००१ तक जोड़ें तो २१ महीने आय मै इसका फार्मूला जानना चाहता हूँ

  4. Hi..I couldn't find these practice files on your website. Also it took me to a new website named: your help in downloading those practice files.Thanks!

  5. Thnak you for your efforts "Guru" May God bless you always ..

    i need help i want to minus the time like 09:3009:29 '' a lower value by higher value 
    it is actually advance arrival of the objects those are coming ahead of time please help me 

Leave a Reply

Your email address will not be published. Required fields are marked *