SumByColor(Rng)

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

In article <jWa9g.28119$fG3.10364@dukeread09>, "JimMay" <jmay@cox.net>
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" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-15DC00.22571412052006@msnews.microsoft.com:

> Why not just use the same conditional in your formula that is used in
> the CF?
>
> In article <jWa9g.28119$fG3.10364@dukeread09>, "JimMay" <jmay@cox.net>
> 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