The SUMIFS function in Excel is used to sum multiple criteria by Chris Menard

The SumIfs Function is an awesome Excel function. It came out with Excel 2007. It is superior to the Sumif function. The Sumif function only allows one criterion. The Sumifs function allows 29 criteria. In this video I look at referencing cells with Sumifs, using operators with sumifs.
Examples of SUMIFS:
States are listed in column A, Cities are listed in column B, and Purchase amount in column C.
To find the total purchases by State and by a specific city in column B, use SUMIFS. An example of the formula would be =SUMIFS(C2:C12, A1:A12. "GA", B1:B12, "Atlanta") would find all purchases for Atlanta, GA customers.
With the SUMIFS function, the sum range comes first. Followed by criteria. The criteria has two arguments, the criteria range and then the criteria.
Chris Menard's Website:
chrismenardtra...
Upcoming MBA events in Excel:
October 5, 2019 - Chris Menard trains the Executive MBA students at the Terry College of Business in Atlanta, GA in Excel.
chrismenardtra...
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtra...
○ Screenshots - Snagit - chrismenardtra...
○ KZbin keyword search - TubeBuddy - www.tubebuddy....
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[@irynasavchenko91]

I've never used the combo of SUM and SUMIFS before! Thank you for the insight and clear explanations!

[@ChrisMenardTraining]

You're so welcome!

[@alain001]

You, sir, are the first person on youtube who I can play at 1.75x speed! :-) That being said - much appreciated tutorial. Exactly what I've came for. Thanks!

[@PrettyBrownEyes1971]

Thanks so much for sharing this information so clearly! I truly appreciate it. 😀

[@ChrisMenardTraining]

You are so welcome!

[@adolfocaldera6485]

Great video, super helpful. I really liked that trick with the brackets

[@ChrisMenardTraining]

Glad you liked it!! Thank you, Adolfo.

[@istolelime]

@@ChrisMenardTraining thanks for the very helpful video! if I use brackets or parentheses instead of braces, would the result still be the same? or would the function still work?

[@CJ3WT]

Exactly what I was looking for. Great video.

[@ChrisMenardTraining]

Awesome, thank you!

[@pearsof]

Sooo helpful, thank you, thank you!

[@ChrisMenardTraining]

You're so welcome!

[@phoenixboyz]

What is the formula for cumulative sales for multiple criteria? example Purchases by San Diego, by month (Jan), by advertising source (google Ads)

[@ChrisMenardTraining]

Use SUMIFS. Here is a screenshot. drive.google.com/file/d/1Xbu0HiXVkSlrelZd9H7N3Xw519dqT3X2/view?usp=drivesdk

[@tejasvypammi2357]

Hai has very clear information that is shared in the video, but I'm facing one problem when I was using this formula. like when we used to write multiple names in the array it was very difficult to do the work.can you please help me in the shortest way by matching the data

[@sarahaddady6044]

Could you please provide the sample file and training list for all of your videos. I subscribed but I really need the sample files that you are explaining on.

[@GrevePenguins11]

What if I want to do a range. I want to see all between 1000 and 1200 e.g.

[@ubaidillahmuhammad20]

nice job. please given the file

[@jillbork2683]

I would like a webinar on tips in outlook email 😊

[@ChrisMenardTraining]

I'll try to schedule one for September. I'll keep you posted.

[@Helloimtheshiieet]

Cool except good luck using multiple sumifs on any real datasets LOL. 5min saves times, freezes, forced to open workbook to update values. Worst function in all of Excel performance wise.