sum of every other two columns

[sem_lady]

Hi I have data in columns A through DU. I'm looking for a formula that will
add every other two columns example.

sum(A1,B1,E1,F1,I1,J1)

 

[Tim879]

You can try using Sum Product to do this.

A quick and dirty way would be to add a row to the top of your sheet.

In row 1, put 1, 0, 1, 0, 1, 0..... in each of the columns

The in your sumproduct formula, you would say:
=sumproduct(A2U2,$a$1:$DU$1)

This formula will add each column that has a 1 in row 1.

 

[Peo Sjoblom]

One way

=SUMPRODUCT((MOD(COLUMN(A1:J1),4)={1;2})*(A1:J1))

--


Regards,


Peo Sjoblom

 

[Domenic]

Try...

=SUM(IF(ISNUMBER(MATCH(MOD(COLUMN(A1U1)-COLUMN(A1),4)+1,{1,2},0)),A1U
1))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!