Wednesday 29 November 2017

Excel - Count cells that match criteria - COUNTIF

Match criterion exactly

Match criterion in a string

Criterion and operator


Match criteria in a range



Change Operator for COUNTIF Function

Use the Drop Down List



False Duplicates With COUNTIF




Count cells that match multiple criteria -- COUNTIFS

Count cells that match multiple criteria - SUMPRODUCT

Count Rows in a Filtered List - SUBTOTAL


Count Specific Items in a Filtered List






Microsoft Accredited IT Training Provider
Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators
Microsoft MOS Test Centre London
















No comments:

Post a Comment