View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
guitara guitara is offline
external usenet poster
 
Posts: 2
Default 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?