cumulative sum of even or odd rows

[shorouqelsobkey]

I need a formula to cumulatively sum the even rows or columns.

Example:

A B
10 10
20 20
60 70
75 95

 

[Jonmo1]

Try this in B1 and filled down.

=SUMPRODUCT(--(MOD(ROW(A$1:A1),2)=MOD(ROW(A1),2)),A$1:A1)

 

[Jonmo1]

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

Cell Formulas
Range	Formula
B1	=A1
B2	=A2
B3	=B1+A3
B4	=B2+A4
B5	=B3+A5
B6	=B4+A6

 

[shorouqelsobkey]

Its working fine but i want it to make it on columns from F35:ZZ35

 

[shorouqelsobkey]

it's working fine, but i need it on columns from F35:ZZ35

 

[Jonmo1]

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

Cell Formulas
Range	Formula
F37	=SUMPRODUCT(--(MOD(COLUMN($F35:F35),2)=MOD(COLUMN(F35),2)),$F35:F35)
F38	=F35
G37	=SUMPRODUCT(--(MOD(COLUMN($F35:G35),2)=MOD(COLUMN(G35),2)),$F35:G35)
G38	=G35
H37	=SUMPRODUCT(--(MOD(COLUMN($F35:H35),2)=MOD(COLUMN(H35),2)),$F35:H35)
H38	=F38+H35
I37	=SUMPRODUCT(--(MOD(COLUMN($F35:I35),2)=MOD(COLUMN(I35),2)),$F35:I35)
I38	=G38+I35
J37	=SUMPRODUCT(--(MOD(COLUMN($F35:J35),2)=MOD(COLUMN(J35),2)),$F35:J35)
J38	=H38+J35
K37	=SUMPRODUCT(--(MOD(COLUMN($F35:K35),2)=MOD(COLUMN(K35),2)),$F35:K35)
K38	=I38+K35

 

[shorouqelsobkey]

thats great but it's only working on even columns what about odd ones ?

 

[Jonmo1]

I may be missing something, but it looks like it works to me as shown in post #6

 

[shorouqelsobkey]

Unfortunately the formula is not working, it says #VALUE!

 

[Jonmo1]

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.