Using the COUNTA function

G

Guest

I have used the COUNTA function to count the number of non-blank cells.
However, it seems to be adding 1 to the total.
For example- one person on the spreedsheet had ALL blank cells in the
selected range- but shows a value of 1.
The formula I'm using is:
=COUNTA(C6,E6,G6,I6,K6,M6,O6,Q6,S6,U6,W6,Y6,AA6,AC6,)
I have checked the contents of each cell and there is nothing in them.

I have checked all the other rows and they have all added 1 to the total
number.

What am I doing wrong?
 
G

Guest

I've managed to fix this myself- the addtional comma at the end was my problem.
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top