Formula based on colours in cell range

Hi, I would like to create a formula which totals the values of a specific cell range that is of a specific colour.

For example. If cell range B4:F7 is red then total the sum of the values, if cell range B4:F7 is Green, total the sum of the values (ignoring red and vice versa).

Any help is much appreciated.

Kind Regards

KB

See http://www.xldynamic.com/source/xld.ColourCounter.html

Hi Martin,

The colours are specific to a name. Name 1 = Green and Name 2 = Red. The values entered are related to the "name's" effort i.e. 'Name 1' = 3(hours). The formula will then look at the cell range and be able to detect the colours and total the values for that specific name.

Not sure if that clarifies?

thanks for your assistance!

KB