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