COUNT - How To
 

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(D2:D567,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

COUNT - How To
 

=COUNTIF(D2:D567,0)


--
Regards,

Peo Sjoblom




"Ardy" wrote in message
ps.com...
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(D2:D567,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

COUNT - How To
 

On Sep 6, 9:30 am, "Peo Sjoblom" wrote:
=COUNTIF(D2:D567,0)

--
Regards,

Peo Sjoblom

"Ardy" wrote in message

ps.com...

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(D2:D567,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.....?

COUNT - How To
 

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(D2:D567)+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.


--
Regards,

Peo Sjoblom

COUNT - How To
 

On Sep 6, 10:22 am, "Peo Sjoblom" wrote:
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(D2:D567)+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.

--
Regards,

Peo Sjoblom

Thanks for the info.......