Count is not working

[[email protected]]

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

[oldchippy]

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

Hi Richard,

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

oldchippy

PS - Don't put this in column D, else you get a circular reference, in other words you are trying to include the answer in the question

[SteveW]

Count counts numbers
you said list of names
try counta

Steve

On Wed, 16 Aug 2006 13:24:43 +0100, <[email protected]> wrote:

> 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:
>
> =3Dcount(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
>



-- =

Steve (3)

[Don Guillett]

try countA

--
Don Guillett
SalesAid Software
[email protected]
<[email protected]> wrote in message
news:[email protected]...
> 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
>

[[email protected]]

It worked, thank you.
[email protected] wrote:
> 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

[Ken Wright]

Might also want to consider looking at Data / Subtotals for that kind of info.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------
It's easier to beg forgiveness than ask permission :-)



"[email protected]" wrote:

> 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
>
>