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