SUMIF Function in Excel Tutorial

In this step-by-step tutorial, learn how to use the SUMIF Function in Microsoft Excel. With sumif, you can sum cells that meet a certain criteria. Along with SUMIF, we also look at how to use the SUMIFS function, which allows you to sum based on multiple criteria.

👋 Additional resources

⌚ Timestamps
0:00 Introduction
0:44 SUMIF formula
2:59 SUMIF with wildcards
4:15 SUMIFS - one criteria
5:41 SUMIFS - multiple criteria
10:08 Other functions
10:37 Wrap up

📃 Watch related playlists

🚩 Connect with me on social

🙏 Request How To Tutorial Videos

🔔 Subscribe to my YouTube channel

🎬 Want to watch again? Navigate back to my YouTube channel quickly

⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.

#stratvert

[sirmium]

One of your best tutorials regarding Excel...

[seliphawaigwa]

Anyone else who attempted the 1st example of SUMIFS multiple rows formula and still got a zero(0) instead? How did you get it to show 28 and 32?

[kofimaracktv]

Hello sir, please I need assistance writing VBA codes to insert passport pictures into picture content in MS Word document if about 20 pages.
James, Ghana, West Africa.

Thank you.

[databurst]

Hey Kevin, I don't know why I am getting zero as result in sumifs multiple rows. I double checked and i am entering the same formula as you, I even changed the country from United States to India but then I am getting only 75 instead of 107 in result when I selected chocolate chip and oatmeal raisins. Could you or anyone help me with this?
this is the formula that I used : =SUM(SUMIFS(C:C, B:B, B2, A:A, A2:A3))

[nemrabboud]

Hi. In sheet1 have a column with 4oo names and in sheet 2 I have a column with 60 names. I need to find which names in sheet 2 exist in sheet 1 and give me the row numbers they are in. What function does that?

[lewis]

There's alot of tutorials about excel on youtube but your tutorials are easy to understand! ty

[jethrobo]

using ver. 2019 (version 2204 (build 15128.20224) — on the sumfs function - it won't give the array (as it does w/your version). Tried several times to be sure I was doing just as you did. Have you any idea what's wrong? BTY: Love your videos!

[dwang]

I’m a big fan of how you always show the insert function process. a lot of tutorials just do it all in the cell or the formula bar which is fine, but using the insert function really adds a little something extra. It’s those kind of things that are the reasons the KCC is at the top of its game!!🤩👨‍🍳🍪🍪🍪

[Jakeindbox]

Easily the best tutorial maker on Youtube. My new job makes a lot of use of the Sumif formulae and this definitely helped me understand it more!

[UsmanKhan-cjvn]

Sir with due respected we need tutorial on VLOOKUP also .Thank You

[theeditorlegacy]

One of the best thing about dude is that he never takes credit for himself ❣️❣️keep growing bro...
All the best

[learningwithmaliha]

Explained beautifully the very confused concept of Sumif and its family.

[neo]

Excel is funny in foreign languages, when you have to translate all this commands 🙈

[austinboyd]

Can you use =SUMIF to add .05 cents on the dollar for beverage crv tax for below 24 oz and .10 cents on the dollar for above 24 oz? Or is there a different method for that?

[rickytomun]

Thank you so much. I really appreciated this video. I'm on a deadline at work and I have no excel training. This video really helped me. 👍 Kevin and 👍 for creating contents that help users

[iESTO]

What if my criteria includes being withing a certain time period? Lets say the cookie transaction dates for each cookie type were tracked and i wanted to know how many chocolate chip cookies were sold in the US this month (there is data from the previous months). How would i ago about including that criteria?

[rickytomun]

Thank you so much. I really appreciated this video. I'm on a deadline at work and I have no excel training. This video really helped me. 👍 Kevin and 👍 for creating contents that help users

[tsamichuzyme]

We appreciate your efforts making these informative and education videos. These content are definitely valuable to all people using Excel at work and schoo. Thank you so much for the help.

[RogerStocker]

I only use the =*IFS() functions since they are available just to have always the same syntax regardless the number of criteria(s).

[naglaa]

Please I want video about cube function