why can't I use functions on a defined multiple range ?
eaxample; average(rangetotal) where rangetotal is defined as cells A1-A5 +
A7-A10
(Rangetotal is a dynamical range which grows in size and number of multi
ranges)