Indeed it is beautifully rendered Max. If you intend to use this again, may
I suggest that you also show how you can dynamically pick up the test
colour, that is by using
as I think this is a useful but not obvious feature (I know it could be
derived from what you do, but ...).
And also summing the values in the coloured range
Post back if Max's workbook doesn't solve the problem for you. I have found
that most problems are caused by people thinking that the function is a
built-in, not one that you have to copy and input to the workbook. Of
course, that may not be your problem, but give us as much detail as you can
if and when posting back.
(replace somewhere in email address with gmail if mailing direct)
"Max" wrote in message
Try this working sample from my archives**:
(Full details & beautifully rendered ..)
**link in sign-off below
"HANYANA" <[email protected] wrote in message news:[email protected]
i have been trying to get the Color Index summing formula to work but i
unsuccessful, i went onto this site
http://www.xldynamic.com/source/xld....r.html#summing but have
gotten no where for some reason the formula will not work and i am left
scratching my head again. If anyone can help i would really appreciate
i have come to a complete standstill with my roster.