Counting/Summing cells with the same conditionally formated color

[becow13]

I am trying to do two things: 1. count the number of cells that have the same background cell color and 2. sum the values in those cells that have the same background cell color. I am new to Excel so i need the most simple way to do this please. Thanks in advance!

[FDibbins]

try and use a filter based on the cell color you want, and then use a count() and sum() for the values left.

alternatively, how do the cells get their colors? if there is some for of conditional formatting involved, you cold base your tota and sum on that?

[becow13]

That will not work because i will constnatly have to change the formula. This is a tracking spreadsheet, so the number of rows of reds, yellows, and greens will constantly be changing. Any other suggestions?

[royUK]

You need to count the conditions that cause the colour change

So if the Condition is that a cell in A1 to A10 = 5 the colour changes

=SUMIF(A1:A10,5,A1:A10)

=COUNTIF(A1:A10,5)