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 