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: With the formula =ROWS () * COLUMNS ()-COUNTBLANK () you need to enter the range address 3 times. Press Enter on your keyboard. You will see the result in the selected cell. If you want to count only constants without cells with extra spaces, use =SUM (-- (LEN (TRIM (range))>0)) Please note, this is an array formula that needs to be entered with CTR + Shift + Enter. Select any empty cell in your sheet. 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.