shorouqelsobkey
New Member
- Joined
- Nov 23, 2015
- Messages
- 30
I need a formula to cumulatively sum the even rows or columns.
Example:
A B
10 10
20 20
60 70
75 95
Example:
A B
10 10
20 20
60 70
75 95
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 |