COUNTIF | COUNTIFS | SUMIF | SUMIFS | AVERAGEIF

Описание: In this video you will discover how to create COUNTIF, COUNTIFS, SUMIF, SUMIFS and AVERAGEIF functions, see the differences and similarities between them and learn which situations require which function

There are plenty of examples to follow.

TIME CODES (click the link to go directly to that spot in the video)
(0:00) Intro
(0:38) The COUNTIF function
(1:42) The COUNTIFS function
(2:58) The AVERAGEIF function
(3:57) The SUMIF function
(4:49) The SUMIFS function (example 1)
(5:45) The SUMIFS function (example 2)
(6:43) How to handle a BETWEEN scenario for numeric data

😃 If you found this video useful, don't forget to give a thumbs up.

😃 What ONE thing resonated with you the most? Let me know by adding a quick COMMENT or question below.

Go get ‘em.

😃 USEFUL LINKS:
Share this Video:
   • COUNTIF | COUNTIFS | SUMIF | SUMIFS | AVER...  

My 30 Best Excel Power Tips
https://officemastery.com/lm/30-excel...

😃 SUBSCRIBE if you want to see more content like this
https://www.youtube.com/c/JasonMorrel...

😃 HIRE JASON to fix your broken spreadsheets or to get private 1-on-1 Zoom coaching
https://trst.com.au/microsoft-trouble...

😃 ABOUT THE PRESENTER:
Jason Morrell helps people of all levels to leverage the power of Microsoft Office. Delivering training since 2002, he loves to simplify the hard stuff and provide helpful, actionable advice that has been proven to slash hours from daily computer tasks. Jason lives with his wife and 4 kids on the beautiful Gold Coast in Queensland, Australia.

😃 LET'S CONNECT!
https://officemastery.com (free training on the blog)
  / officemastery  
  / jkmorrell  
   / jasonmorrell  

Have a fantastic day!