Thread
:
summing non contiguous ranges
View Single Post
#
1
Posted to microsoft.public.excel.misc
valaor
Posts: n/a
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?
Reply With Quote