SUMIF based on cell shading

[IlliniEric]

Is it possible to write a SUMIF formula based on cell shading? If so, how? I
want to add up cells based on the shading of the cell. Thanks.

 

[Gord Dibben]

How did the cells get shaded?

If by Conditional Formatting then use the same criteria in your SUMIF

If manually shaded you will need VBA

See Chip Pearson's site for code.

http://www.cpearson.com/excel/colors.aspx


Gord Dibben MS Excel MVP