Formula Help

[Spraggs]

Evening
Is there an easier way to enter this formula?
=SUM(B6,D6,F6,H6,J6,L6,N6,P6,R6,T6,V6,X6,Z6,AB6,AD6,AF6,AH6,AJ6,AL6,AN6,AP6,AR6,AT6,AV6,AX6,AZ6,BB6,BD6,BF6,BH6,BJ6)
When I try to enter this it returns too many arguments.
I'm trying to sum every other row from B:BJ
Thanks Jase

 

[Marcelo Branco]

Hi,

If you wand to sum only the even columns (B, D, F....) maybe this
=SUMPRODUCT(--(MOD(COLUMN(B6:BJ6),2)=0),B6:BJ6)

HTH

M.

 

[Spraggs]

Thats great.
How do I alter it to do every other one from C6 to BK6?

 

[Spraggs]

Sorted.

=SUMPRODUCT(--(MOD(COLUMN(C6:BK6),2)=1),C6:BK6)

Thank You

 

[Aladin Akyurek]

Sorted.

=SUMPRODUCT(--(MOD(COLUMN(C6:BK6),2)=1),C6:BK6)

Thank You

Try this pair...

=SUMPRODUCT(--(MOD(COLUMN(B6:BK6)-COLUMN(C6),2)=0),B6:BK6)

=SUMPRODUCT(--(MOD(COLUMN(B6:BK6)-COLUMN(C6)+1,2)=0),B6:BK6)

 

[Marcelo Branco]

Sorted.

=SUMPRODUCT(--(MOD(COLUMN(C6:BK6),2)=1),C6:BK6)

Thank You

Good!

All the best

M.