Excel formula - Sum colors cells

Highlighted
Occasional Visitor

Hi,

Can you please update me if there is an option to sum all cells with specific colors?

should

I use CountIF or SUMIF? 

Thanks in advance.

1 Reply
Highlighted

Hi,

 

Right place for this question is Excel commnity https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat, Formulas and Functions space.

 

Short answer - Excel functions like COUNTIF and SUMIF work with cells' values, thus nope. To work with cells' properties like color you need to use VBA, when it'll be possible. Or find workaround if your colors are based on some defined within the sheet logic, e.g. conditional formatting.