Excel Quick Tips - How to use the COUNTIFS function
Excel Quick Tips - How to use the COUNTIFS function
Grab my FREE Excel for Analytics Ultimate Guide here: https://www.tmbanalytics.com/excel-fo...
Want to learn some helpful Excel functions? In this short I show you a quick use case for the COUNTIFS function to instantly count the number of customers by region from my example data set, which you can access if you check out my Excel for Analytics project series here: • Excel for Analytics Project Series
The Syntax is as follows:
=COUNTIFS(Criteria 1 Range, Criteria 1, Criteria 2 Range, Criteria 2, etc.)
Where:
Criteria Range means the series of data that has criteria you want to count
Criteria here means what specifically you are counting from the range
In our example we grab the criteria range (region column in the data table), and we match against our criteria list, which are the unique regions.
Have fun!
#excel #exceltips #analytics #data #dataanalytics #excelfunctions #tmbanalytics #countifs