Getting a total for everyother row

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
both, someone sent me a spreadsheet with number of accounts and then dollars for account under. I need totals for both.
 
Upvote 0
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?
 
Upvote 0
RedSoxHugh said:
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)
 
Upvote 0
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
:eek: :eek:
 
Upvote 0
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.
 
Upvote 0
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.

Insert a row before the current row 1...
 
Upvote 0

Forum statistics

Threads
1,212,138
Messages
6,106,173
Members
448,003
Latest member
ZdenekP

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top