count function??

  • Thread starter Thread starter nonnaca
  • Start date Start date
N

nonnaca

I am running a program with information that changes several times
during the day. There are several rows that need to be counted, but
that number changes with the addition and subtraction of information,
however my excel only counts the information one time (when i
originally put in the counta function) but does not recount when i
change the information in the columns.
plz help....
data looks like this

name
name
name
name
empty cell
name
name
total number of names.
Thanks
Aaron
 
I have found that putting the count formulas above the dataset is much
better, since you can set the formula to look down to 50000 rows, even
though your data might occupy only 30. but it will count any that happen to
come beneath those still, so Id suggest moving your count formula above the
data.
 
Back
Top