COUNTIF function


Counts cells that match the specified criteria.



=COUNTIF( rangecriteria )


required arguments:

range The range of cell to check.
criteria The condition that controls which cell will be displayed.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.