View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bill gras bill gras is offline
external usenet poster
 
Posts: 48
Default average sum of 5rows

Hi All

I have a column of 1020 rows with numbers , I need to average the sum
of every 5 rows down to 1020 rows eg-
a d
1 52
2 60
3 64
4 40
5 71 57.6
6 203
7 150
8 11
9 25
10 93 96.4

Can any one help me please
Thanks in advance
--
bill gras