One way:

Assuming that the colors aren't applied by Conditional Formatting:

http://cpearson.com/excel/colors.htm

If they are applied by CF, do a conditional sum using the same condition
as your CF.


In article ,
Duncan wrote:

I have a spreadsheet with several rows. The background of the rows can
either be coloured Red, Orange, Green or white.

What I want to do is have a running total for each colour, so that if a row
is set with a green background it will increment the Green total by one. If
an Orange row is changed to Red, the Orange count will drop by one, and the
Red count will go up by one.

Is this possible, and if so, how?

Rgds

Duncan