Please Help Formula

[melle]

Hi,

In column A I have let's say 1000 numbers. In cell B1 I want the
average of cells
A:10, A:20, A:30, A:40 etc. etc. A990:A1000

How can I copy the formula to 1000.

I hope someone can help me.

Regards,

Melle

Netherlands

 

[Guest]

You're asking how to get the average of the values in every 10th cell, right?

=AVERAGE(IF(MOD(ROW(A1:A1000),10)=0,A1:A1000))

this is an array formula, so enter it with the key combination of
Ctrl+Shift+Enter