How to Count Cells That are Not Blank in Excel – 8 Methods

The dataset contains dollar values in Accounting format.

Method 1 – Using the COUNTA Function

Use the COUNTA function. It counts cells with given criteria.

Steps:

• Go to D10 and enter the following formula:
`=COUNTA(B4:D9)`

• Press Enter.

It will calculate the total number of non-empty cells in B4:D9.

Method 2 – Applying the COUNTIF Function

The COUNTIF function counts cellsÂ  that meet a single condition.

Steps:

• Go to D10 and enter the following formula:
`=COUNTIF(B4:D9, "<>"&"")`

• Press Enter.

This is the output.

Method 3 – Utilizing the COUNTIFS Function

The COUNTIFS function can take multiple conditions.

Steps:

• Go to D10 and enter the following formula:
`=COUNTIFS(B4:D9,"<>")`

• Press Enter.

This is the output.

Method 4 – Count Non-Blank Cells Using the COUNTBLANK Function

The COUNTBLANK function counts the number of blank cells.

Steps:

• Go to D10 and enter the following formula:
`=ROWS(B4:D9)*COLUMNS(B4:D9)-COUNTBLANK(B4:D9)`

• Press Enter.

This is the output.

Method 5 – Using the SUMPRODUCT Function

The SUMPRODUCT function count cells that are not blank.

Steps:

• Go to D10 and enter the following formula:
`=SUMPRODUCT((B4:D9<>"")*1)`

• Press Enter.

This is the output.

Method 6 – Applying LEN Function to Count Non-Blank Cells

The LEN functionÂ  measures the length of a text string. Use this function with the SUMPRODUCT function to count cells that are not blank.

Steps:

• Go to D10 and enter the following formula:
`=SUMPRODUCT(--(LEN(B4:D9)>0))`

• Press Enter.

This is the output.

Method 7 – Utilizing the Find & Select Feature

Steps:

• Select B4:D9.
• Go to the Home tab and click Find & Select in Editing.
• Click Find.

• In the Find and Replace window, enter * in Find what and click Find All.

This is the output.

Method 8 – Counting using the Status Bar

Steps:

• Select B4:D9.
• You will see the total number of filled cells at the bottom of the Excel window.

How to Count Blank Cells in Excel

Steps:

• Go to D10 and enter the following formula:
`=COUNTBLANK(B4:D9)`

• Press Enter.

This is the output.

<< Go Back to Count Cells | Formula List | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!