Troy is all over the place posting..

--

Regards,

Peo Sjoblom


"Myrna Larson" wrote in message
...
If all that is wanted is to sum the odd-numbered rows:

=SUMPRODUCT((B2:B32)*(MOD(ROW(B2:B32),2)))

or the even-numbered rows:

=SUMPRODUCT((B2:B32)*(1-MOD(ROW(B2:B32),2)))

Of course this is less flexible than your formula, which allows one to do
every 3rd or 4th row,
etc.


On Sat, 25 Oct 2003 17:11:37 +0100, "Bob Phillips"
wrote:

Troy,

Do you want a formula?

This formula will sum every nth value from the mth item in the range,
assuming in this case a range of B2:B32. Just change m and n to your
values
(1 and 2 in your case), and all references to the applicable range

=SUMPRODUCT((B2:B32)*(MOD(ROW(B2:B32)-ROW(B2),n)+1=m))