Forum Discussion

dlamg's avatar
dlamg
Copper Contributor
Jun 14, 2017

Excel formula - Sum colors cells

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.

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jun 14, 2017

    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.