K
KRM
how may I devise a formula for adding only alternate cells in columns?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
Even rows: =SUMPRODUCT(--(MOD(ROW(B1:B30),2)=0),B1:B30)
Odd rows; =SUMPRODUCT(--(MOD(ROW(B1:B30),2)=1),B1:B30)
--
HTH
RP
(remove nothere from the email address if mailing direct)
Odd rows; =SUMPRODUCT(--(MOD(ROW(B1:B30),2)=1),B1:B30)
--
HTH
RP
(remove nothere from the email address if mailing direct)
H
Harlan Grove
Bob Phillips said:Even rows: =SUMPRODUCT(--(MOD(ROW(B1:B30),2)=0),B1:B30)
Odd rows; =SUMPRODUCT(--(MOD(ROW(B1:B30),2)=1),B1:B30)
Yes, but if you had the sum of even rows in, say, X99, then it'd be more
efficient to calculate the sum of odd rows using
=SUM(B1:B30)-X99
B
Bob Phillips
True, but he asked for summing alternate rows without saying whether he
wanted odd or even, so I gave him both. He did not say he wanted two sums,.
Bob
wanted odd or even, so I gave him both. He did not say he wanted two sums,.
Bob
A
Aladin Akyurek
KRM said:how may I devise a formula for adding only alternate cells in columns?
=SUMPRODUCT(--(MOD(ROW(A3:A8)-ROW($A$3)+0,2)=0),A3:A8)
Replace the +0 bit with +1 if summing must start with the first 2nd value.
Note that 2 (the Nth row parameter) can be any admissible value, odd or
even.
K
KRM
I'm grateful to you for this help. I'd never have got it by myself. Thanks,
KRM
KRM
K
KRM
I'm grateful to you for this help. I'd never have got it by myself. Thanks,
KRM
KRM
K
KRM
I'll bet that's a great solution but it's like a PHD coaching a
kindergardener. Many thanks anyway. KRM
kindergardener. Many thanks anyway. KRM