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(A2:DU2,$a$1:$DU$1)

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


On Oct 3, 4:44*pm, sem_lady
wrote:
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)