counting by color
I've got it, thanks for your help guys.
"JE McGimpsey" wrote:
That works for me for font color (after recalculating - just changing
the font color doesn't cause a recalc). You did intend font color (i.e.,
TRUE in the 3rd argument), right?
However, there are two "yellows" in the default Color Palette - the pale
one is ColorIndex 36.
In article ,
cc wrote:
Thanks for your assistance I'm a beginner at this and still cant seem to get
it. I have inserted the following as I'm using yellow
=SUMBYCOLOR(DD4:DD19,6,TRUE)
|