| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
easier way to do this?
I have a column of numbers in A, and I want B1=average(A1:A10) ,
B2=average(A11:A20), B3=average(A21:30).......................... Is there any way to do this calculation? I can not input each equation in column B, since I have lots of data. Can I set a function by myself? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
easier way to do this?
=AVERAGE(OFFSET(A$1,10*(ROW()-ROW(B$1)),0,10,1)) in B1, and copy down.
-- David Biddulph "guitara" wrote in message ups.com... I have a column of numbers in A, and I want B1=average(A1:A10) , B2=average(A11:A20), B3=average(A21:30).......................... Is there any way to do this calculation? I can not input each equation in column B, since I have lots of data. Can I set a function by myself? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
easier way to do this?
On Aug 21, 3:47 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote: =AVERAGE(OFFSET(A$1,10*(ROW()-ROW(B$1)),0,10,1)) in B1, and copy down. -- David Biddulph "guitara" wrote in message ups.com... I have a column of numbers in A, and I want B1=average(A1:A10) , B2=average(A11:A20), B3=average(A21:30).......................... Is there any way to do this calculation? I can not input each equation in column B, since I have lots of data. Can I set a function by myself?- Hide quoted text - - Show quoted text - Great! Thanks a lot! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| got to be an easier way? | Excel Discussion (Misc queries) | |||
| There's Got to be an Easier Way | Excel Discussion (Misc queries) | |||
| Is there an easier way? | Excel Discussion (Misc queries) | |||
| Easier Way? | Excel Worksheet Functions | |||
| There has to be any easier way!! | New Users to Excel | |||
Hybrid Mode
