tally of nonblank cells

[AustinMom]

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

 

[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

 

[AustinMom]

It worked! Thanks so much!

 

[Pete_UK]

You're welcome.

Pete

It worked! Thanks so much!