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 o...
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)?
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)?