Average Non-Contiguous numbers

J

Jason Morin

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
 
Top