Hi!
I wanted to know how I can sum up values in a cell based on it's interior color?
So I have filled in the color for these cells (range F4:F67):
And then I would like the worksheet tab to sum up the values here based on the colors, so if I change the color of one of the cells, it automatically calculates the value to the right PL (A73:A77)
I wanted to know how I can sum up values in a cell based on it's interior color?
So I have filled in the color for these cells (range F4:F67):
And then I would like the worksheet tab to sum up the values here based on the colors, so if I change the color of one of the cells, it automatically calculates the value to the right PL (A73:A77)