Forum Discussion
Need help
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
By the way, I found no one conditional formatting rule here, are they applied?
- 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)?
