thank you both for your response
I did try the comma to separate the ranges, but could not get it to work.
The non contiguous named range worked a treat

regards

Barb Reinhardt wrote:
I haven't tried it, but I think I'd try to create a non-contiguous named
range and put that in your formula.
Hi

[quoted text clipped - 10 lines]

Brian

--
Message posted via http://www.officekb.com