Excel formula - Sum colors cells

Copper Contributor


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


I use CountIF or SUMIF? 

Thanks in advance.

1 Reply



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.