Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula average
Hi,
I have in column A valuea (numbers in A1:A1000). I want to compute the average of the numbers in cells A10:A20:A30:A40 etc... etc... A990:A1000. Does someone know a formula for this problem. Manually is too much work. |
#2
|
|||
|
|||
Hi melle,
pls try this =average(cell ref) anirudh "Melle" wrote: Hi, I have in column A valuea (numbers in A1:A1000). I want to compute the average of the numbers in cells A10:A20:A30:A40 etc... etc... A990:A1000. Does someone know a formula for this problem. Manually is too much work. |
#3
|
|||
|
|||
Why do you keep asking the question if you are going to ignore the
answers? If you don't understand the answers you have already received to your previous posts, reply back to the answer requesting clarification instead of repeating the same question over and over again. Jerry Melle wrote: Hi, I have in column A valuea (numbers in A1:A1000). I want to compute the average of the numbers in cells A10:A20:A30:A40 etc... etc... A990:A1000. Does someone know a formula for this problem. Manually is too much work. |
#4
|
|||
|
|||
I am sorry. In the future I willp ost my questions only once. -- melle ------------------------------------------------------------------------ melle's Profile: http://www.excelforum.com/member.php...o&userid=26981 View this thread: http://www.excelforum.com/showthread...hreadid=473716 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average formula | Excel Discussion (Misc queries) | |||
Formula to average certain times | Excel Discussion (Misc queries) | |||
Average Formula | Excel Discussion (Misc queries) | |||
AVERAGE and STDEV functions with logic | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |