Countif

5 lessons in order

Learn how to use COUNTIF in Excel to count cells that contain text from a list and track how many keywords appear in each cell accurately.

Learn how to use COUNTIF and COUNTIFS in Excel to apply multiple criteria across columns, handle OR logic, and count keyword occurrences.

Learn how to use COUNTIF in Excel to calculate percentages for text, numeric thresholds, completion rates, and non-blank responses easily.

Learn how to use COUNTIF in Excel to count values not equal to zero, including tips with SUMPRODUCT, FILTER, and other functions.

Learn how to fix Excel COUNTIF returning 0 with tips on quotes, wildcards, OR/AND logic, and using COUNTIFS for multiple conditions.