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/garjdxm4gmdcuoa...
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 theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #sumif #sumifs
Негізгі бет Excel: SUMIF is Outdated. Here’s What to Use Instead
Пікірлер: 9