| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i calculate the difference between two numbers? | Excel Discussion (Misc queries) | |||
| Can I calculate just one worksheet in a multi-worksheet workbook? | Excel Discussion (Misc queries) | |||
| how do you calculate a column of numbers - eg. A1 to A20? | Excel Discussion (Misc queries) | |||
| Calculate numbers between 2 dates | Excel Discussion (Misc queries) | |||
| Calculate In-Between Numbers | Excel Worksheet Functions | |||
Linear Mode
