Sum Calculation

R

rob

How do I create a formula to tell Excel to sum every other
row in a column? Thank you for your assistance
 
E

EarlK

Rob,

This is for even numbered rows. Change 0 to 1 for odd numbered rows.

=SUMPRODUCT((MOD(ROW(B2:B8),2)=0)*(B2:B8))
 
Top