ExcelBanter - View Single Post - Totalling numbers that are Conditionally Formatted

In article ,
Ann Knoff <Ann wrote:

Is there any way to total up a column by the colours of a cell?

I have a column that has Green, Yellow, Amber and Red cells and I need to
add up how many of each are there and then calculate the percentage.

Any help would be gratefully received!

Since the numbers are conditionally formatted, use the same condition in
your sum. For instance, if values less than 0 are formatted as red, use

=SUMIF(A:A,"<0")/COUNT(A:A)

(formatted as a percentage).