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
Bookmarks