Huh? Do you mean that all of the cells in A2:A7 aren't filled, i.e. the DATA
isn't contiguous (certainly those CELLS are contiguous).

Let's say there is data in ALL of those cells, but he only wants to average
A3, A4, A5, and A6. I don't see how your formula will average just those
cells.

On Thu, 3 Mar 2005 23:16:54 -0000, "Andy Brown"
wrote:

"Myrna Larson" wrote in message
.. .
But A2:A7 is not a group of non-contiguous cells. I think the example he
gave
was A1, A3, A5

Of course, but A2:A7 can *contain* a group of non-contiguous cells.