sum of every other two columns

S

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)
 
T

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

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

Peo Sjoblom

One way

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

--


Regards,


Peo Sjoblom
 
D

Domenic

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top