Excel Quick Tips - How to use the COUNTIFS function

Excel Quick Tips - How to use the COUNTIFS function

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

[Fsp]

More of this please. Thanks a ton for making these vodeos

[lisamccray]

I love this video. I hope others will find out that you do these short Excel videos. You are great at this.

[tjbroussard]

Are we able to build off of pivot tables this way?

[grizzlytomemi]

How do I countif from a table, not just a column

[mojtabareyhani]

Excellent as always,
Just a request:
Please use more internationally words and speak more slowly, Because you have huge global audiences.
Thank you so much.

[sakshimenghrajani]

From where did you write geoby client.. cant understand that

[aggwoow]

What's the difference between countifs and sumifs?

[mattbrattin]

Interested in taking my free Analytics Career Foundations course? Find it at and sign up today!