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

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

Similar Threads

Multiple IF Statement in Word 5
How to Update SUM formula after inserting rows 2
formula for arriving net difference 0
Autonumber field in Excel that behaves the same as Access 0
Sharing Excel 365 Mac<->PC 0
M.S. Word 365 1
changing rows *and* columns in automatic formulae 1
Sum to a mid point in a dynamic table 2

Top