Jun 13 2017 11:26 PM - edited Jun 14 2017 12:19 AM
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.
Jun 14 2017 04:05 AM
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.