RedSoxHugh
New Member
- Joined
- Nov 15, 2005
- Messages
- 4
I'm new at this, how do I get a total at the bottom for everyother row?
RedSoxHugh said:I'm new at this, how do I get a total at the bottom for everyother row?
NBVC said: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.