Count Cells

4 lessons in order

Learn how to count cells containing numbers in Excel using COUNT, COUNTIF, COUNTIFS, SUBTOTAL, and SUMPRODUCT with practical examples.

Learn how to count cells with specific text in Excel using COUNTIF, SUMPRODUCT, FILTER, wildcards, VBA, and more.

Learn how to count filtered cells with text in Excel using SUBTOTAL, COUNTIFS, and formulas to count visible text only.

Learn how to count colored cells in Excel without VBA using Filter and SUBTOTAL, Find and Replace, and GET.CELL with named ranges.