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