View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
valaor
 
Posts: n/a
Default summing non contiguous ranges

I need to sum cells A1:A5, C1:C5, E1:E5 etc, i.e. the first top 5 cells in
every second column. I must sum more than 50 such ranges, so SUM(A1:A5,
C1:C5, ...) is not an option. Can this be done with formulas?