View Single Post
  #1   Report Post  
Mjc39 Mjc39 is offline
Junior Member
 
Posts: 1
Default Sum a column in groups

Hey I was wondering if there was a way to have a column summed up in a certain total. Like i have a 100 numbers in a column I can get the column split summed into 5 different groups of 20. I would also it need it to skip blank cells. and sum the first 20 values as they appeared in the column.

Thanks in advance