| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
