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?
.