Count is not working

  • Thread starter Thread starter eyeman6513_2000
  • Start date Start date
E

eyeman6513_2000

Okay, this is BASIC and I feel bad for asking, but I can not get my
count to work.

I have a spreadsheet with a list of doctors names and other
information, I tried to do a count on the column using the following
formula:

=count(D:D)

And Excel gave me 0.

I tried this on other columns, it worked, there is no formula in the
column, my spreadsheet is not on manual calculate, when using the
little ghost function in Excel I am able to get a count for the row in
question, but the formula won't work. I found a work around by
counting another column, any ideas on why it is not working?

Richard
 
Okay, this is BASIC and I feel bad for asking, but I can not get my
count to work.

I have a spreadsheet with a list of doctors names and other
information, I tried to do a count on the column using the following
formula:

=count(D:D)

And Excel gave me 0.

I tried this on other columns, it worked, there is no formula in the
column, my spreadsheet is not on manual calculate, when using the
little ghost function in Excel I am able to get a count for the row in
question, but the formula won't work. I found a work around by
counting another column, any ideas on why it is not working?

Richard
Click to expand...

Hi Richard,

If you're counting text, use =COUNTA(D:D)

oldchippy :)
 
Back
Top