Average A10:A20:A30 etc... A990;A1000

[melle]

A1:A1000 is filled with values. I want the average A10: A20: A30 etc.... A990:A1000 in cell B1

Manually it is too much work. The formule should be somethinge like
=average(A10 & 10 (Range1:1000))

I hope someone can help me. I am not that expierenced with Excel

Regards,

Melle

[Roger Govier]

Hi Melle

You already had an excellent solution from Duke to your posting of this
question under a different thread.
If you had a problem with the array formula, here is a non array
alternative.

=SUMPRODUCT(--(MOD(ROW(A1:A100),10)=0),A1:A1000)/SUMPRODUCT(--(MOD(ROW(A1:A100),10)=0)

It helps if you keep your postings about the same problem in the same
thread, as others can then see easily what solutions you have been
offered so far.

Regards

Roger Govier



melle wrote:

>A1:A1000 is filled with values. I want the average A10: A20: A30 etc....
>A990:A1000 in cell B1
>
>Manually it is too much work. The formule should be somethinge like
>=average(A10 & 10 (Range1:1000))
>
>I hope someone can help me. I am not that expierenced with Excel
>
>Regards,
>
>Melle
>
>
>
>

[Murtaza]

Correction, In case someone might use in future like I did today
=SUMPRODUCT(--(MOD(ROW(A1:A1000),10)=0),A1:A1000)/SUMPRODUCT(--(MOD(ROW(A1:A
1000),10)=0))

"A1:A100" replaced by "A1:A1000"

Regards,
Murtaza

"Roger Govier" <roger@nospamtechnology4u.co.uk> wrote in message
news:4343E21D.5060905@nospamtechnology4u.co.uk...
> Hi Melle
>
> You already had an excellent solution from Duke to your posting of this
> question under a different thread.
> If you had a problem with the array formula, here is a non array
> alternative.
>
>
=SUMPRODUCT(--(MOD(ROW(A1:A100),10)=0),A1:A1000)/SUMPRODUCT(--(MOD(ROW(A1:A1
00),10)=0)
>
> It helps if you keep your postings about the same problem in the same
> thread, as others can then see easily what solutions you have been
> offered so far.
>
> Regards
>
> Roger Govier
>
>
>
> melle wrote:
>
> >A1:A1000 is filled with values. I want the average A10: A20: A30 etc....
> >A990:A1000 in cell B1
> >
> >Manually it is too much work. The formule should be somethinge like
> >=average(A10 & 10 (Range1:1000))
> >
> >I hope someone can help me. I am not that expierenced with Excel
> >
> >Regards,
> >
> >Melle
> >
> >
> >
> >