For Google Sheets: =SUMIF(ARRAYFORMULA(MOD(COLUMN(B1:Z1),2)),0,B1:Z1) Change the range in both places to suit your needs. Successfully sums the values of every other column.