Hi all,
I am using cells A15 through Z 100
I color code cells and want to add the totals. So in Cell A1 I want the total of all green colored cells. A2 I want the total of red, etc.
One caveat, I merge cells all throughout A15 to Z100, so I only want to count the colored cell once not each one within the merge.
Any chance on a formula for that?
Thanks so much
I am using cells A15 through Z 100
I color code cells and want to add the totals. So in Cell A1 I want the total of all green colored cells. A2 I want the total of red, etc.
One caveat, I merge cells all throughout A15 to Z100, so I only want to count the colored cell once not each one within the merge.
Any chance on a formula for that?
Thanks so much