Counting Cells in Excel

From NovaOrdis Knowledge Base

Jump to navigation Jump to search

Internal

Microsoft Excel

Overview

To count the number of cells that contain texts (not numbers, not errors, not blank), use COUNTIF() and a wildcard:

=COUNTIF(A1:A10, "*")

Retrieved from "https://kb.novaordis.com/index.php?title=Counting_Cells_in_Excel&oldid=66885"