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

R

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
 
G

Gary''s Student

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

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

Luke M

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top