SUMIF COUNTIF SUMIFS COUNTIFS | Summing and Counting with Criteria
SUMIF COUNTIF SUMIFS COUNTIFS | Summing and Counting with Criteria
You can download the workbook here to follow along with the Video!
Need to get the sum of sales for a certain product with a certain color?
Need to sum the sales for the USA only?
This is when SUMIF, SUMIFS, COUNTIF, and COUNTIFS come to the rescue!
In this tutorial, I explain how these functions work and how you can use them to sum and count with one or more criteria including summing and counting based on numbers!
Make sure to watch the video to learn how to use these awesome functions! They are surely going to pump your Excel skills!
I hope you like that Tutorial.
Please watch the video and let me know if you have any comments or feedback in the comments section below.
Please share
If you like this post, don’t forget to Share it with your friends on different social media platforms using the share buttons!
Ace your Excel Career by learning how to create Excel Dashboards!
Learn Step by Step how to create Professional, Interactive Dashboards & Charts using Excel including:
1- Learning the Important functions that you need to know for building Dashboards such as VLOOKUP, HLOOKUP, MATCH, INDEX, OFFSET and others
2-Learning how to implement Interactivity tools such as Form Controls, Slicers, and others.
3-Learning Dashboarding techniques.
4- Building a Complete Excel Dashboard.
Click here Find out more
Leave A Comment