Forum Discussion
KBmentions
Apr 25, 2022Copper Contributor
adding up numbers of colours in a column
Please can someone help. I have coding which determines a colour in a column dependant on a figure. I want to add up all the reds in the column and all the greens in the same column. Does anyo...
HansVogelaar
Apr 25, 2022MVP
I'd use SUMIF or SUMIFS formulas using the same conditions that determine the cell's color.