tally of nonblank cells

G

Guest

I have tried to use the =COUNTA( ) function, but when I select the range of
cells to tally, I don't get a number of cells, I get only the function
 
P

Pete_UK

The cell with the formula in is probably formatted as Text. Use Format
| Cells | Number (tab) to confirm this, and select General or Number
with 0 dp. To get Excel to react to this change, double-click the cell
(as if to edit it) then click elsewhere.

Hope this helps.

Pete
 

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

Similar Threads

count nonblank cells 3
Excel Count If Formula Question 1
count nonblank cells with conditions 2
I want to tally my sheet 6
Tally function assistance 4
push result from one cell to another 2
extracting quarterly data and having it update daily 1
BAG_DEG_DOLU_SAY (COUNTA) 2

Top