SUMIF based on cell shading
 

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.

SUMIF based on cell shading
 

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

On Wed, 17 Feb 2010 12:55:01 -0800, IlliniEric
wrote:

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.