Title: How to Count Non Blank or Non Empty Cells in Excel | Excelchat How to Count Non Blank or Non Empty Cells in Excel
Headings: How to Count Non Blank or Non Empty Cells in Excel
How to Count Non Blank or Non Empty Cells in Excel
Using Excel Status Bar Count
Using Excel Find and Replace functionality
Using Excel Formulas to count Non Blank cells
=COUNTA (B2:B7)
=COUNTIF (B2:B7,"<>"&"")
=SUMPRODUCT (-- (LEN (TRIM (B2:B7))>0))
Did this post not answer your question? Get a  solution from  connecting  with the expert.
Another blog reader asked this question today on Excelchat:

Content: Each formula is designed to count such cells based on what kind of filled cells you need to count. Here we will discuss these formulas in details. COUNTA function
Excel COUNTA function is designed to count all those cells that are filled with values (both text and number), formulas (returning empty text (“”) or values), spaces, or formula errors. Following formula gives you count of students who have grades’ values. =COUNTA (B2: B7)
COUNTIF function
Excel COUNTIF function counts cells that meet the condition Not Equal to empty (“<>”&””). This formula also counts cells that are filled with values, formulas, spaces, or formula errors. In this example, It will give you total count of cells where student have grades and also cells that have even blank formula, such as; =COUNTIF (B2: B7,"<>"&"")
SUMPRODUCT, LEN and TRIM functions
If you want to ignore cells that are filled with only spaces and formulas returning empty text (“”), and only want to count those cells that are filled with values then you need to combine these three functions in single formula in following way;