Getting a total for everyother row

[RedSoxHugh]

I'm new at this, how do I get a total at the bottom for everyother row?

 

[NBVC]

Try these:

For even rows: =SUM(IF(MOD(ROW(A1:A100),2)=0,A1:A100))

For odd rows: =SUM(IF(MOD(ROW(A1:A100),2)=1,A1:A100))

Formulas must be confirmed with Ctrl+Shift+Enter, not just Enter.

Adjust ranges to suit.

Insert a row before the current row 1...

I think I see what you are saying, so it would be assumed that no rows are inserted above the range, and if rows are inserted above or below the range, the range in the formulas must be adjusted.

Correct me if I am wrong, but I tried your formula, Aladin and when inserting a row above, I get the same issue.


Did I understand your comment correctly, then?

 

[Aladin Akyurek]

Try these:

For even rows: =SUM(IF(MOD(ROW(A1:A100),2)=0,A1:A100))

For odd rows: =SUM(IF(MOD(ROW(A1:A100),2)=1,A1:A100))

Formulas must be confirmed with Ctrl+Shift+Enter, not just Enter.

Adjust ranges to suit.

Insert a row before the current row 1...

I see what you are saying, so it would be assumed that no rows are inserted above the range, and if rows are inserted above or below the range, the range in the formulas must be adjusted...

Nothing has to be assumed if you use the formula(s) I posted.

 

[NBVC]

Nothing has to be assumed if you use the formula(s) I posted.

I guess I don't get it, then. If you insert a row above A3 and use your formula, I get a similar issue. The top of the range in your formulas change to A4 and now don't include A3.