Try this in B1 and filled down.
=SUMPRODUCT(--(MOD(ROW(A$1:A1),2)=MOD(ROW(A1),2)),A$1:A1)
This is a discussion on cumulative sum of even or odd rows within the Excel Questions forums, part of the Question Forums category; I need a formula to cumulatively sum the even rows or columns. Example: A B 10 10 20 20 60 ...
I need a formula to cumulatively sum the even rows or columns.
Example:
A B
10 10
20 20
60 70
75 95
Try this in B1 and filled down.
=SUMPRODUCT(--(MOD(ROW(A$1:A1),2)=MOD(ROW(A1),2)),A$1:A1)
Add-in for posting ranges as copyable tables (bottom of the page) -Win & Mac
The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.
Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
Ferris Bueller A.K.A. John Hughes, 1986
Here's a more efficient and simpler method..
Excel 2010
A B 1 10 10 2 20 20 3 60 70 4 75 95 5 20 90 6 100 195 Sheet1
Worksheet Formulas
Cell Formula B1 =A1 B2 =A2 B3 =B1+A3 B4 =B2+A4 B5 =B3+A5 B6 =B4+A6
Add-in for posting ranges as copyable tables (bottom of the page) -Win & Mac
The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.
Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
Ferris Bueller A.K.A. John Hughes, 1986
Its working fine but i want it to make it on columns from F35:ZZ35
it's working fine, but i need it on columns from F35:ZZ35
Same concept, just change from row to column..
Here's both methods
Excel 2010
F G H I J K 35 10 20 60 75 20 100 36 37 10 20 70 95 90 195 38 10 20 70 95 90 195 Sheet1
Worksheet Formulas
Cell Formula F37 =SUMPRODUCT(--(MOD(COLUMN($F35:F35),2)=MOD(COLUMN(F35),2)),$F35:F35) G37 =SUMPRODUCT(--(MOD(COLUMN($F35:G35),2)=MOD(COLUMN(G35),2)),$F35:G35) H37 =SUMPRODUCT(--(MOD(COLUMN($F35:H35),2)=MOD(COLUMN(H35),2)),$F35:H35) I37 =SUMPRODUCT(--(MOD(COLUMN($F35:I35),2)=MOD(COLUMN(I35),2)),$F35:I35) J37 =SUMPRODUCT(--(MOD(COLUMN($F35:J35),2)=MOD(COLUMN(J35),2)),$F35:J35) K37 =SUMPRODUCT(--(MOD(COLUMN($F35:K35),2)=MOD(COLUMN(K35),2)),$F35:K35) F38 =F35 G38 =G35 H38 =F38+H35 I38 =G38+I35 J38 =H38+J35 K38 =I38+K35
Add-in for posting ranges as copyable tables (bottom of the page) -Win & Mac
The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.
Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
Ferris Bueller A.K.A. John Hughes, 1986
thats great but it's only working on even columns what about odd ones ?
I may be missing something, but it looks like it works to me as shown in post #6
Add-in for posting ranges as copyable tables (bottom of the page) -Win & Mac
The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.
Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
Ferris Bueller A.K.A. John Hughes, 1986
Unfortunately the formula is not working, it says #VALUE!
Which one?
I'd suggest the simpler method (not the sumproduct)
Perhaps your numbers are not really numbers..
What does this return
=ISNUMBER(F35)
And fill it accross.
Add-in for posting ranges as copyable tables (bottom of the page) -Win & Mac
The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.
Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
Ferris Bueller A.K.A. John Hughes, 1986
Like this thread? Share it with others