sum of every other two columns
 

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)

sum of every other two columns
 

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)

sum of every other two columns
 

One way

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

--


Regards,


Peo Sjoblom

"sem_lady" wrote in message
...
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)

sum of every other two columns
 

Try...

=SUM(IF(ISNUMBER(MATCH(MOD(COLUMN(A1:DU1)-COLUMN(A1),4)+1,{1,2},0)),A1:DU
1))

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

Hope this helps!

In article ,
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)