in the worksheet, a1 to a10 have numbers. I want to calculate to a

[raymond]

in the worksheet, a1 to a10 have numbers. I want to calculate to average
value for two value. i.e. average(a1:a2),
average(a3:a4),......average(a9:a10) (no. of average value=5).
If the data range is from a1 to a100, then the above method seems very
unconvenient because no. of averge value=50)

CAN ANY ONE GIVE ME A HELP??

bY Raymond

 

[Gary''s Student]

In B2 enter:
=AVERAGE(A1:A2) and copy down column B

You don't have to re-type each formula.

 

[Luke M]

=AVERAGE(INDIRECT("A"&ROW(A1)*2-1&":A"&ROW(A1)*2))
And copying down will do what you want.