Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Average Non-Contiguous numbers
I can't figure out how to average non-contiguous numbers. Any suggestions?
|
#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 -----Original Message----- I can't figure out how to average non-contiguous numbers. Any suggestions? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Help creating a formula, pulling from a set of static numbers. | Excel Worksheet Functions | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
How do I drop the lowest 2 numbers and then average? | Excel Worksheet Functions | |||
finding common numbers in large lists | Excel Worksheet Functions |