At 15:12, an hour before this thread, in your previous post, you said you
had got it working. What's up?

--
HTH

Bob Phillips

" Inserting an option button in Word"
soft.com wrote in message
...
I would like to know how to sum a range depending on cell background
colour
so if range was background colour red for example it would sum all the red
shaded cells that have numbers in them. Any help appreciated