To sum yellow use

=SUMIF(A1:A100,"=43")-SUMIF(A1:A100,"56")

apply the same technique to the other conditions

--
Regards,

Peo Sjoblom

(No private emails please)


"Ann Knoff" wrote in message
...
Thank you for responding so quickly. Unfortunately I still can't get it
to
work (probably because I am a complete novice)!

The column the conditional formatting in is the O column and the
conditions
I am using are as follows:

If the number is between 43 and 56 - Yellow
If the number is between 57 and 84 - Amber
If the number is greater than or equal to 85 - Red

(Oh and the default is Green which is less than or equal to 42 but I
couldn't get 4 conditional formatting items to work)

Any more help you can give would again be greatly appreciated

Ann

"JE McGimpsey" wrote:

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