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. |
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. |
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. |
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 |
All times are GMT +1. The time now is 04:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com