Count

5 lessons in order

Learn how to count cells with values in Google Sheets using COUNTA, COUNTIF, COUNT, and COUNTBLANK functions for accurate data tracking.

Learn how to count non-empty cells in Google Sheets using COUNTA, COUNTIF, and ARRAYFORMULA while filtering spaces and applying conditions.

Learn how to count unique values in Google Sheets using COUNTUNIQUE, UNIQUE with COUNTA, COUNTIF, SUMPRODUCT, and FLATTEN for advanced cases.

Learn how to count highlighted cells in Google Sheets using Apps Script, Function by Color add-on, or COUNTIF for text-based highlights.

Learn how to count cells with specific text in Google Sheets using COUNTIF, case-sensitive formulas, multiple criteria, FILTER & REGEXMATCH.