Need help

%3CLINGO-SUB%20id%3D%22lingo-sub-1766509%22%20slang%3D%22en-US%22%3ENeed%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766509%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20technical%20question%20for%20a%20formula%20or%20conditional%20formatting%20issue.%20I%20have%20the%20following%20spreadsheet.%20I%20have%20certain%20cells%20which%20are%20colour%20coded.%20I%20would%20like%20to%20have%20the%20total%20cells%2C%20total%20only%20the%20similar%20coloured%20cells%20automatically%20rather%20than%20manually.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3A%20Cells%20in%20the%26nbsp%3B%20%22F%22%20Column%20are%20colour%20coded.%20Each%20Colour%20code%20has%20a%20distinct%20total%20Cell%20in%20this%20case%20cell%20F4%20and%20those%20similarily%20coloured%20are%20totalled%20in%20N7.%26nbsp%3B%3C%2FP%3E%3CP%3EF5%20and%20similarly%20coloured%20cells%20are%20totalled%20in%20L7%20and%20so%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20want%20to%20do%20is%20%22IF%22%20there%20is%20a%20amount%20listed%20in%20Column%20%22G%22%20that%20corresponding%20number%20is%20added%20to%20the%20total%20in%20the%20associated%20total%20column.%20This%20would%20be%20done%20for%20each%20colour%20under%20F%2FC%20Class%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1766509%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1766616%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766616%22%20slang%3D%22en-US%22%3EI'm%20not%20aware%20of%20any%20built-in%20way%20to%20count%2Fsum%20by%20color.%20But%2C%20can't%20you%20just%20sum%20by%20the%20classification%20code%20using%20sumif%3F%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20cell%20K8%3A%3CBR%20%2F%3E%3DSUMIF(%24F%244%3A%24F%2459%2CK7%2C%24G%244%3A%24G%2459)%3CBR%20%2F%3E%3CBR%20%2F%3Eand%20copy%20across.%20Adjust%20the%20ranges%20if%20you%20need%20to%20(cell%20L8%20total%20appears%20to%20include%20rows%20greater%20than%2058%20to%20get%2074%2C%20but%20N8%20and%20O8%20don't)%3F%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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 Replies
Highlighted
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)?
Highlighted

@davepaul39 

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