Is it possible to sum every other row ?
Or maybe sum rows where the row number is odd (or even) ?
I'm looking at the SUMIF function, but I don't think that can handle what I am trying to do.
Anyone ?
Printable View
Is it possible to sum every other row ?
Or maybe sum rows where the row number is odd (or even) ?
I'm looking at the SUMIF function, but I don't think that can handle what I am trying to do.
Anyone ?
never mind ... got it
I used :
=SUMPRODUCT((MOD(ROW(A1:A1000)-ROW(A1),2)=0)*(A1:A1000))
:)