Sum the Nth Column (Sum every other column) Excel 2007/2010 Formula

=SUMPRODUCT(–(MOD(COLUMN(B4:X4),3)=MOD(COLUMN($B4),3)),(B4:X4))

NOTE:
Substitute your range for B4:X4. Notice that the reference $B4 is locked on the column but not the row. This will allow you to autofill this formula down in a database or table.

 

Leave a Reply

Your email address will not be published. Required fields are marked *