Hi All,

I am trying to find a formula that lets me add the values based on the color of the cell. You can see i have 4 different colors that i’m using but just used three for this example. I want to be able to sum up the value based on the color and put under Column R, S & T. This has to work even if i move the colors around.

​Hi All,I am trying to find a formula that lets me add the values based on the color of the cell. You can see i have 4 different colors that i’m using but just used three for this example. I want to be able to sum up the value based on the color and put under Column R, S & T. This has to work even if i move the colors around.  Read More

​