Average Non-Contiguous numbers
 

I can't figure out how to average non-contiguous numbers. Any suggestions?

I would suggest creating as many merged ranges as
possible, such as:

=AVERAGE(A1:A2,B1:B4)

rather than

=AVERAGE(A1,A2,B1,B2,B3,B4)

If, after doing that, you need more than 30 arguments,
you can use this technique:

http://tinyurl.com/4pcsk

or used defined names.

HTH
Jason
Atlanta, GA



-----Original Message-----
I can't figure out how to average non-contiguous
numbers. Any suggestions?
.