I'm not very savy with excel but I manage to figure most stuff out but I am having a hard time trying figure out how to sum by color with conditional formatting.
I have a column of invoice amounts that I need to total the amounts by color. My rows are formatted to highlight a specific color when I enter a provider name.
I found a way to sum by color but it only worked for cells whose color was set manually not using conditional formatting. Once conditional formatting was applied this method no longer worked.
X511:X530 (20 cells) for each provider total, Range is X35:X489
Any help would be greatly appreciated, thank you.
I have a column of invoice amounts that I need to total the amounts by color. My rows are formatted to highlight a specific color when I enter a provider name.
I found a way to sum by color but it only worked for cells whose color was set manually not using conditional formatting. Once conditional formatting was applied this method no longer worked.
X511:X530 (20 cells) for each provider total, Range is X35:X489
Any help would be greatly appreciated, thank you.