Can I count the number of cells that contain data?

  • Thread starter Thread starter Geek
  • Start date Start date
G

Geek

Hi all,

I am creating a spreadsheet that is a chart and each day I track an item and
enter a date. Can I just count the number of cells contain dates...I am not
interested in calculation of contents or averages. All that I care is that
excel can see that I have entered data in that cell or row and it counts it
as one and keeps a running total. So, if I have data entered in 5 cells in a
particular row, it will give me a running count of how many cells have the
data, in this case 5, and show that number at the top of my sheet somewhere
that I can see it easily.

Thanks in advance!
 
Hi

Counting data in row 4:
=COUNTA(4:4)
but it will count more than dates -your description is somewhat confusing on
what to count.

HTH. Best wishes Harald
 
Thanks Harald!


Harald Staff said:
Hi

Counting data in row 4:
=COUNTA(4:4)
but it will count more than dates -your description is somewhat confusing on
what to count.

HTH. Best wishes Harald

in
Click to expand...
 
Back
Top