View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KLock KLock is offline
external usenet poster
 
Posts: 16
Default Adding every sixth value

I have to add every sixth value in a column summed over 52 value. Is there
an equation to do this so I don't have to input each cell.

Example

Column 1 2 3 4 5 1 2 3 4 5

So the equation I need is Column (1+1), Column (2+2), so on