software

Hello,

I have a need to sum the values in every other cell, and sometimes every
third cell, in a column or row.

Thanks
--
Brent

=SUMPRODUCT(--(MOD(ROW(A1:A20),2)=1),A1:A20)

gets A1,A3, etc.

To get A2,A4, etc. then change =1 to =0.

For every third, do a MOD(...,3)

etc.

--

HTH

RP

quot;Brentquot; gt; wrote in message
...
gt; Hello,
gt;
gt; I have a need to sum the values in every other cell, and sometimes every
gt; third cell, in a column or row.
gt;
gt; Thanks
gt; --
gt; Brent
Gonna have to modify this a little, depending on how your data is set up.
This formula assumes your data range is A1:A20, and the number of rows in
between that you want to skip in the sum is located in B1.

=SUMPRODUCT((MOD(ROW(A1:A20),B1)=0)*(A1:A20))

So, if you had 2 located in B1, this formula will give you a sum of
A2 A4 A6 ... A20.

If you have a 3 located in B1, this formula will give you a sum of
A3 A6 A9 ... A18.

--
Regards,
Davequot;Brentquot; wrote:

gt; Hello,
gt;
gt; I have a need to sum the values in every other cell, and sometimes every
gt; third cell, in a column or row.
gt;
gt; Thanks
gt; --
gt; Brent