Getting a total for everyother row

[RedSoxHugh]

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

 

[SteveO59L]

Odd rows or Even rows ?

 

[RedSoxHugh]

both, someone sent me a spreadsheet with number of accounts and then dollars for account under. I need totals for both.

 

[Pekkavee]

maybe just

=SUM(A1,A3,A5,A7 ) etc and
=SUM(A2,A4,A6,A8) etc.

Pekka

 

[RedSoxHugh]

tried that, I get an error because there are too many cells, the report is 70 lines long. Is there a formula that recognizes grabbing evens or odds in general?

 

[Aladin Akyurek]

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

1.

=SUMPRODUCT(--(MOD(ROW(A3:A8)-ROW(A3)+0,2)=0),A3:A8)

2.

=SUMPRODUCT(--(MOD(ROW(A3:A8)-ROW(A3)+1,2)=0),A3:A8)

 

[Pekkavee]

You could use an extra column
Put there
1
2
1
2
1
2
1

Etc.
Then use
=SUMIF(B1:B70,1,A1:A70) and
=SUMIF(B1:B70,2,A1:A70)

Pekka

 

[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.

 

[texasalynn]

try something like this

Book1
	A	B	C	D
1	7050-1	1
2	100	0
3	7050-2	1
4	100	0
5	7050-4	1
6	100	0
7	7050-1	1
8	7050-2	0
9	100	1
10	7050-4	0
11	100	1
12	7050-1	0
13	100	1
14	7050-2	0
15	100	1
16	7050-4	0
17	100	1
18	300
Sheet1

HTH

 

[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...