COUNT - How To

[Ardy]

Hello All:
OK I am a bit confused. I have a bunch of data, Column D has various
digits that signify different things fore example 0 = Apple 10 =
Orange. I am doing a simple count [=COUNT(D2567,0)] to get a count
of 0's instead I get the count of all data which sums up to be 567.
what Am I doing wrong

Ardy

 

[Peo Sjoblom]

=COUNTIF(D2567,0)

 

[Ardy]

=COUNTIF(D2567,0)

--
Regards,

Peo Sjoblom

Hello All:
OK I am a bit confused. I have a bunch of data, Column D has various
digits that signify different things fore example 0 = Apple 10 =
Orange. I am doing a simple count [=COUNT(D2567,0)] to get a count
of 0's instead I get the count of all data which sums up to be 567.
what Am I doing wrong

Ardy

Please explain the difference........
I thought once you give it the range and the variable after , is the
one that it suppose to count.....?

 

[Peo Sjoblom]

Please explain the difference........
I thought once you give it the range and the variable after , is the
one that it suppose to count.....?

No, I assume you have looked at it in help and frankly the example does not
make any sense, all it does is to add 1 count to the total. It will not
differentiate between 0 or 2 in the range you are using so it is not a
variable that COUNT uses to count all zeros (in your example), who wants to
count the cells that contain numeric values in let's say A1:A10 then add
another numeric value hard coded, you might as well use?

=COUNT(D2567)+1


All I can say is that although you can use COUNT with criteria (you can if
you use array formulas) in this case it would be insane since COUNTIF will
do the work.

 

[Ardy]

No, I assume you have looked at it in help and frankly the example does not
make any sense, all it does is to add 1 count to the total. It will not
differentiate between 0 or 2 in the range you are using so it is not a
variable that COUNT uses to count all zeros (in your example), who wants to
count the cells that contain numeric values in let's say A1:A10 then add
another numeric value hard coded, you might as well use?

=COUNT(D2567)+1

All I can say is that although you can use COUNT with criteria (you can if
you use array formulas) in this case it would be insane since COUNTIF will
do the work.

Thanks for the info.......