Hello!
I have a problem with ”summarization”.
See the picture (it’s a minimized example).
I have one tab (tab 2) with result in 8 different categories (the color is dynamic depending on an answer in tab 1).
In tab 3 I want to sum these categories, both with colors and the number of “the worst color”. (Done with a formula and conditional format.)
The formula is kind of:
IF one is RED mark it red, and calculate the amount of red in that category.
ELSE IF one is GREY mark it grey, and calculate the amount of grey in that category.
ELSE IF mark it green, and calculate the amount of green in that category.
This I can do because I have “hidden” numbers (numbers of the same color as the cell) in the result. So 2 is RED, 1 is GREY and 0 is GREEN. Easy to use in formula.
But now I want to sum up the numbers of RED, GREY and GREEN from the total result (to an “end result”).
I can´t find any way to do that… =(
(It has to be done without macron.)
What I have read, I can´t look of what color a cell has (without macron).
I do have an idea of adding (and hiding decimals) 0,2 vs 0,1 vs 0,0 in the total result. And looking for the numbers of “X,2“ with MOD(), but can´t make it work neither.
Do anyone have an idea I would be very grateful!!
Regards
Magnus
I have a problem with ”summarization”.
See the picture (it’s a minimized example).
I have one tab (tab 2) with result in 8 different categories (the color is dynamic depending on an answer in tab 1).
In tab 3 I want to sum these categories, both with colors and the number of “the worst color”. (Done with a formula and conditional format.)
The formula is kind of:
IF one is RED mark it red, and calculate the amount of red in that category.
ELSE IF one is GREY mark it grey, and calculate the amount of grey in that category.
ELSE IF mark it green, and calculate the amount of green in that category.
This I can do because I have “hidden” numbers (numbers of the same color as the cell) in the result. So 2 is RED, 1 is GREY and 0 is GREEN. Easy to use in formula.
But now I want to sum up the numbers of RED, GREY and GREEN from the total result (to an “end result”).
I can´t find any way to do that… =(
(It has to be done without macron.)
What I have read, I can´t look of what color a cell has (without macron).
I do have an idea of adding (and hiding decimals) 0,2 vs 0,1 vs 0,0 in the total result. And looking for the numbers of “X,2“ with MOD(), but can´t make it work neither.
Do anyone have an idea I would be very grateful!!
Regards
Magnus