Count

C

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
 
J

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

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.
Click to expand...


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 [email protected]
 
Top