Need help

[davepaul39]

I have a technical question for a formula or conditional formatting issue. I have the following spreadsheet. I have certain cells which are colour coded. I would like to have the total cells, total only the similar coloured cells automatically rather than manually.

For example: Cells in the  "F" Column are colour coded. Each Colour code has a distinct total Cell in this case cell F4 and those similarily coloured are totalled in N7. 

F5 and similarly coloured cells are totalled in L7 and so on.

What I want to do is "IF" there is a amount listed in Column "G" that corresponding number is added to the total in the associated total column. This would be done for each colour under F/C Class

[#2]

I'm not aware of any built-in way to count/sum by color. But, can't you just sum by the classification code using sumif?

In cell K8:
=SUMIF($F$4:$F$59,K7,$G$4:$G$59)

and copy across. Adjust the ranges if you need to (cell L8 total appears to include rows greater than 58 to get 74, but N8 and O8 don't)?

[#3]

@davepaul39 

By the way, I found no one conditional formatting rule here, are they applied?