Count

[Chi]

Hi,
I use condition format for total column.

Ex: >=100 will be red
between 100 and 50 is green

< 50 will be black

I would like to count how many red, green and black I have.

Ex: 10 red, 20 green and 15 black.

Thank you
Chi

 

[JE McGimpsey]

One way:

=COUNTIF(A1:A100,">=100") & " red, " &
SUMPRODUCT(--(A1:A100<100),--(A1:A100>=50)) & " green, " &
COUNTIF(A1:A100,"<50") & " black"

Note, you can't get at CF states directly from the worksheet.

 

[Peter Atherton]

-----Original Message-----
Hi,
I use condition format for total column.

Ex: >=100 will be red
between 100 and 50 is green

< 50 will be black

I would like to count how many red, green and black I have.

Ex: 10 red, 20 green and 15 black.

Chi
Why not just count the values?
=COUNTIF(K10:K12,"<50")
or and array formula
=COUNT(IF(K10:K12<50,K10:K12))
entered as Ctl + Shift + Enter

Peter
Peter (e-mail address removed)