Excel 2016 tutorial on how to place conditions, or criteria on what you want to sum or add up, count up, or average out by using the SUMIF, COUNTIF and AVERAGEIF as well as the plural SUMIFs, COUNTIFs and AVERAGEIFs functions respectively.

All 160 of my Excel 2016 training videos contain everything you need to help pass both the Microsoft Office Excel 2016 Core (77-727), and Expert (77-728) exams and become certified!

PATREON: Kirt Kershaw & Dream Force, LLC invite you to subscribe for the $2 monthly option which includes ALL Microsoft Office training tutorials 2016, 2013, 2010 and 2007. New videos will be constantly uploaded to Patreon so you will get new content. Visit and sign up at: https://www.patreon.com/KirtKershaw

DVD & DOWNLOAD AVAILABLE:
https://www.DreamForce.us

SUBSCRIBE to learn more Microsoft Office tips, tricks and shortcuts!
http://www.youtube.com/subscription_center?add_user=videotrainingpro

LET’S CONNECT!
— http://www.facebook.com/KirtKershaw

— http://www.linkedin.com/in/kirt-kershaw-33874410
— https://www.instagram.com/kirtkershaw

Please take the opportunity to connect and share this video with your friends and family if you find it useful.