In this mow to use SUMIF with multiple columns tutorial, we show you how to use the SUMIFS function to add numbers in a range of cells based on single or multiple criteria.

The SUMIFS function is a much welcome enhancement to an old Excel favorite, SUMIF. Part of the Maths/Trig group of formulas, it can be used to add a range of numbers based on one or more pieces of criteria.

This makes it different from the SUMIF function which could only handle one piece of criteria.

GET FOUR FREE COURSES! ⏩
https://www.simonsezit.com/four-free-courses

Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/

Level up your skills with a a free 30 day trial to our complete training library of 8,500+ video ⏩ https://www.simonsezit.com/ssit-first-month-free

Check out our Google Workspace and Google Sheets for Beginners playlist here
⏩https://www.youtube.com/playlist?list=PLzj7TwUeMQ3j2l5vfMGeUyJ60154MW9-n

Check out our FREE 300+ hour training course playlist here
⏩https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

Watch more popular tutorials from Simon Sez IT:

Microsoft Office 2021 and Office 365 Training Tutorials playlist
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

Microsoft Office 2019 Training Tutorials for Beginners playlist
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i2OE0G9fSMaVjcW4qi_z_7

Excel 2021 Tutorials for Beginners playlist
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jqRlmIaj6jb_X9EGQueMD

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
LinkedIn: https://www.linkedin.com/company/simon-sez-it/

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)