MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Summing every other n columns

Posted by Fendi on February 11, 2002 9:37 AM

I am trying to write a function that would sum every other n columns. The function would ideally look like this:
A2:L2 = row to sum
1 = start adding from the first column
2 = add every other 2 columns.

This function would ideally result in A2+D2+G2+J2


Posted by Mark W. on February 11, 2002 10:23 AM

BTW, here are array formulas that do it...


or, if you like...


Note: These are array formulas which must be
entered using the Control+Shift+Enter key
combination. The outermost braces, {}, are not
entered by you -- they're supplied by Excel in
recognition of a properly entered array formula.

Posted by Mark W. on February 11, 2002 4:52 PM

Just for fun... are some variants using the 2nd formula...

Sum every 3rd column beginning with the 2nd...

Sum every 4th column begining with the 4th...

Sum every other column beginning with the 2nd...

This is just too much fun!! : )