Thread: AVERAGE ARRAY
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vukgar vukgar is offline
external usenet poster
 
Posts: 1
Default AVERAGE ARRAY

I would like to average the 1st 7 numbers in an array (E2:E63), in the next
colum I need to average the 1st 30 numbers of E2:E63). I have tried using
=AVERAGE(E2:E63),ROW(1:7), but the number returned is double than what it
should be