Title: Excel: count non-blank cells using Find and Replace or formulas
Headings: How to count non-empty cells in Excel 2010, 2013
How to count non-empty cells in Excel 2010, 2013
Count option on the Excel Status bar
Excel - count non-blank cells with the Find and Replace option
Use a special Excel formula to count all non-blank cells

Content: Enter =SUM (-- (LEN (TRIM ())>0)) in the formula bar. Place your mouse cursor between the brackets and select the range in your table. You will see the range address appear in the formula. Press Ctrl + Shift + Enter to see the number in the selected cell. On the screenshot below, you can see a brief summary showing how these 3 formulas work with constants, blank formulas and extra spaces. In the test table I have a range with 4 cells selected. A2 contains a value, A3 has a formula that returns an empty string, A4 is empty and A5 has two spaces entered. Under the range, you can see the number of the found cells next to the formula I used to find them. Another way to count non-blanks in Excel is using the COUNTIF formula =COUNTIF (range,"<>"&""). You will find the full details in this tutorial - COUNTIF for non-blanks.