Excel: SUMIF is Outdated. Here’s What to Use Instead

SUMIF and SUMIFS. They're both used to add up numbers in a range that match a criteria. But what's the difference? For many people, the logic as to which function to use is "One criteria...use SUMIF. Multiple criteria...use SUMIFS" and whilst that may be true, SUMIFS can handle both single and multiple criteria so there really is no need to use SUMIF any more
🗒 Notes and Resources
Download a copy of the file used in this video: app.box.com/s/...
The formulas that I used in the demos:
=SUMIF(C2:C39,"Home",E2:E39)
=SUMIFS(E2:E39,C2:C39,"Home",D2:D39,"W",B2:B39,"Sun")
=SUMIFS(E2:E39,C2:C39,"Home")
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at theexceltraine...
🙋‍♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #sumif #sumifs

[@jerrydellasala7643]

Another reason for using SUMIFS rather than SUMIF is because in 2019 several functions that previously had only "IF" versions were updated to have "IFS" versions, and their syntax is all the same in that the data the function is to be applied to is always the first parameter, with Criteria Range/Criteria pairs after that. Those functions are AVERAGEIFS, COUNTIFS, MAXIFS, MINIFS, and of course SUMIFS as well as the IFS function which is slightly different, but a significant improvement over nested IF formulas!

[@RenierWessels]

Thanks for sharing Mike!

[@pandamonium9834]

Morning everyone hope you’ve all had an excel-lent festive break? Happy new year to one and all. Goals scored …….😢 oh dear not enough lol

[@MikeThomas67]

@pandamonium9834 Morning Annie. I should really have made the font larger which would have moved the 0-7 v Liverpool off-screen LOL

[@pandamonium9834]

At least home attendance was fairly consistent

[@amjan]

cryteria - plural noun
cryterion - singular noun

[@MikeThomas67]

@amjan
cryteria/cryterion with a Y - Mis-spelt
criteria/criterion with a I - correct spelling

[@ChrisEdwards1988]

in 2024, i'm not having success with SUMIF or SUMIFS functions actually adding anything, can anyone help?

[@MikeThomas67]

@ChrisEdwards1988 Are the values you are trying to add actually numeric values or are they text entries that look like numbers? I don't want to post my email address here but if you contact me via theexceltrainer.co.uk/contact/ I'm happy to start a conversation with you