Counting Cells in Excel

From NovaOrdis Knowledge Base
Revision as of 16:53, 13 April 2020 by Ovidiu (talk | contribs) (Created page with "=Internal= * Microsoft Excel =Overview= To count the number of cells that contain texts (not numbers, not errors, not blank), use COUNTIF() and...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Internal

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"