Sum formula of cells with specific color value

[MSOChick]

Hello,
I am trying to ceate a SUM formula to add only the green filled
cells in a specified range. I am trying to do it with sum and
cell("color",reference) but I can't seem to be able to find color values. A
formula of: SUM(A3:E3) =CELL("color") simply returns a TRUE value. Any help
would be appreciated.

Thanks,
Lia

[Bob Phillips]

See http://www.xldynamic.com/source/xld.ColourCounter.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"MSOChick" <[email protected]> wrote in message
news:[email protected]...
> Hello,
> I am trying to ceate a SUM formula to add only the green filled
> cells in a specified range. I am trying to do it with sum and
> cell("color",reference) but I can't seem to be able to find color values.
A
> formula of: SUM(A3:E3) =CELL("color") simply returns a TRUE value. Any
help
> would be appreciated.
>
> Thanks,
> Lia

[MSOChick]

Thanks so much! I found a VB that would counts the colors successfully, but
not when text or numbers were added to the cell.

"Bob Phillips" wrote:

> See http://www.xldynamic.com/source/xld.ColourCounter.html
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "MSOChick" <[email protected]> wrote in message
> news:[email protected]...
> > Hello,
> > I am trying to ceate a SUM formula to add only the green filled
> > cells in a specified range. I am trying to do it with sum and
> > cell("color",reference) but I can't seem to be able to find color values.
> A
> > formula of: SUM(A3:E3) =CELL("color") simply returns a TRUE value. Any
> help
> > would be appreciated.
> >
> > Thanks,
> > Lia
>
>
>