SUMIFS Function in Excel - How to Use SUMIFS function with 5 Examples

SUMIFS function in Excel - How to use SUMIFS function with 5 examples and a sample file to download and follow along.

SUMIFS in Excel is one of the best functions. It is so incredibly useful and easy to learn with this video tutorial.

Learn how to use SUMIFS function in Excel including with dates and with multiple criteria.

Download the sample file

Here are the timings of the video.
00:00 - Introduction and download the sample file
00:24 - How to use SUMIFS function in Excel
03:11 - Check the answer
04:01 - Sum values based on a cell value
04:50 - SUMIFS function with multiple criteria
06:06 - SUMIFS testing a numeric value
08:29 - SUMIFS function in Excel using dates

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[wayneedmondson]

Hi Alan. Love SUMIFS! Thanks for sharing this lesson :)) Thumbs up!!

[stavrosbatsaktsis]

That was one great tutorial! Thank you very much, Computergaga!

[lynxwomancat]

I have been learning this function and you drove home the ease of use. Thanks, Alan!

[mohideenthassim]

As usual another great video from you Alan, many thanks

[darrylmorgan]

Cool Tutorial, SUMIFS Is Such A Great Function...Thank You Alan :)

[philipmcdonnell]

Just what I needed, Alan. Many thanks for sharing.

[gregoryunderwood]

Very cool!!! Thank you so much!! I see now what I was doing wrong

[meranism]

Thank you for the information sir. I would like to see if there is a way to apply the same method for several columns? I have a sheet where I input my monthly expenses and I separated it by months. So each month has it's own expenses in different column. Is there a way to get a sum for a specific expense, let say (GAS)? I would really appreciate it if you could help me. Other wise the way I do it now I get a sum for each month and then add up all those numbers to get a sum of all. That's taking a long time to put the same equation for each month over and over again. =SUMIF(A3:A25, "*"&AI5&"*", B3:B25)+SUMIF(C3:C25, "*"&AI5&"*", D3:D25) - this is what I use. but I have to do it for 12 months. Is there a shortcut for achieving the same result?

[emtiazulhoque]

How to download this file from the video link

[akramalazrak]

How can I create a formula as follows?
If I have a value 5, 500, 000
To take up only 1, 000, 000
If the Value is less than 1, 000, 000 remain as itself