Video: COUNTIF function

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

See how to use the COUNTIF function in Excel to count cells that meet the criteria you specify. For example, look up how many times a name appears in a column, or see how many students got a certain grade.

Applies To: Excel 2010

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language