Is there a better formula for adding every other cell

[spectraflame]

I have a need to add every other cell in a row. The only way that I could think of was the following. Is there a better method?

=B7+D7+F7+H7+J7+L7+N7+P7+R7+T7+V7+X7+Z7+AB7+AD7+AF7+AH7+AJ7+AL7+AN7+AP7+AR7+AT7+AV7+AX7+AZ7+BB7+BD7+BF7+BH7+BJ7

 

[mvptomlinson]

The following array formula (confirmed using CTRL+SHIFT+ENTER, not just ENTER) should work:

=SUM(IF(MOD(COLUMN(A7:BJ7),2)=0,A7:BJ7))

 

[kpark91]

Perhaps

=SUMPRODUCT((MOD(COLUMN($A$7:$BJ$7), 2) = 0) * ($A$7:$BJ$7))

 

[yogeshmaney]

=SUM(IF(MOD(COLUMN(B7:BJ7),2)=0,B7:BJ7))


And Enter Ctrl+Shift+ENter

 

[T. Valko]

I have a need to add every other cell in a row. The only way that I could think of was the following. Is there a better method?

=B7+D7+F7+H7+J7+L7+N7+P7+R7+T7+V7+X7+Z7+AB7+AD7+AF7+
AH7+AJ7+AL7+AN7+AP7+AR7+AT7+AV7+AX7+AZ7+BB7+BD7+BF7+BH7+BJ7

Try this...

=SUMPRODUCT(--(MOD(COLUMN(B7:BJ7)-COLUMN(B7),2)=0),B7:BJ7)

This version is robust against new column insertions at the start of the range.

If the cells between the target cells DO NOT contain any numeric values then just a simple SUM formula will do:

=SUM(B7:BJ7)