B Bob Phillips Apr 16, 2005 #2 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)
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)
H Harlan Grove Apr 17, 2005 #3 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) Click to expand... 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
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) Click to expand... 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 Apr 17, 2005 #4 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
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
A Aladin Akyurek Apr 17, 2005 #5 KRM said: how may I devise a formula for adding only alternate cells in columns? Click to expand... =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.
KRM said: how may I devise a formula for adding only alternate cells in columns? Click to expand... =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.
G Guest Apr 18, 2005 #6 I'm grateful to you for this help. I'd never have got it by myself. Thanks, KRM
G Guest Apr 18, 2005 #7 I'm grateful to you for this help. I'd never have got it by myself. Thanks, KRM
G Guest Apr 18, 2005 #8 I'll bet that's a great solution but it's like a PHD coaching a kindergardener. Many thanks anyway. KRM
I'll bet that's a great solution but it's like a PHD coaching a kindergardener. Many thanks anyway. KRM
