SUM odd/even Rows?
If you need a formula you could use this:
where A1:A18 is your range
for odd rows:
=SUMPRODUCT((MOD(ROW(A1:A18),2)=1)*(A1:A18))
for even rows
=SUMPRODUCT((MOD(ROW(A1:A18),2)=0)*(A1:A18))
hth
Carlo
On Jan 10, 8:53*am, TexJen wrote:
Is there a way to select a range, and then SUM only the odd # rows in that
range? *Or, even # rows?
thnx so much
|