I can't figure out how to average non-contiguous numbers. Any suggestions?
J Jason Morin Jan 20, 2005 #2 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
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
