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

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

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

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

You don't have to re-type each formula.
--
Gary''s Student - gsnu200849


"raymond" wrote:

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

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

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

Luke M
*Remember to click "yes" if this post helped you!*


"raymond" wrote:

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