One way ..
In say, B1:
=SUMPRODUCT(--(MOD(ROW(A1:A10),2)=1),A1:A10)
returns the sum of the odd rows within the range A1:A10,
viz the sum of: A1, A3, A5, A7, A9
=SUMPRODUCT(--(MOD(ROW(A1:A10),2)=0),A1:A10)
returns the sum of the even rows within the range A1:A10,
viz the sum of: A2, A4, A6, A8, A10
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"anand" wrote:
is there a formula that allows you to sum alternate rows (even vs odd) or
similar? Can this be done with a variation of the "sumif" function?
anand