Prev: How do i calculate the percentage to compare two different years
Next: countif object
From: IlliniEric on 17 Feb 2010 15:55
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.
From: Gord Dibben on 17 Feb 2010 17:03
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
<IlliniEric(a)discussions.microsoft.com> 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.

 | 
Pages: 1
Prev: How do i calculate the percentage to compare two different years
Next: countif object