SumByColor(Rng)

I use the "normal" SumByColor(Rng,Colorindex) function written by Chip
Pearson. It works on cells colored when done so with the Color Fill
Icon
Or with Format, Cell Pattern, ColorSelect, OK.
But the formula DOES NOT work if the cells (Range) is colored VIA
Conditional Formatting. Does anyone have the code [and would share] to
engage a SumRngWithCondFormating()?
Much appreciate, in advance

Why not just use the same conditional in your formula that is used in
the CF?

In article <jWa9g.28119$fG3.10364@dukeread09>, "JimMay" <[email protected]>
wrote:

> I use the "normal" SumByColor(Rng,Colorindex) function written by Chip
> Pearson. It works on cells colored when done so with the Color Fill
> Icon
> Or with Format, Cell Pattern, ColorSelect, OK.
> But the formula DOES NOT work if the cells (Range) is colored VIA
> Conditional Formatting. Does anyone have the code [and would share] to
> engage a SumRngWithCondFormating()?
> Much appreciate, in advance

Hummm...(??) Thanks JE -- I'll pursue that suggestion.
Jim May

"JE McGimpsey" <[email protected]> wrote in message
news:[email protected]:

> Why not just use the same conditional in your formula that is used in
> the CF?
>
> In article <jWa9g.28119$fG3.10364@dukeread09>, "JimMay" <[email protected]>
> wrote:
>
>
> > I use the "normal" SumByColor(Rng,Colorindex) function written by Chip
> > Pearson. It works on cells colored when done so with the Color Fill
> > Icon
> > Or with Format, Cell Pattern, ColorSelect, OK.
> > But the formula DOES NOT work if the cells (Range) is colored VIA
> > Conditional Formatting. Does anyone have the code [and would share] to
> > engage a SumRngWithCondFormating()?
> > Much appreciate, in advance