software

Hi,

a1,a3,a5.......... =a1 a3 a5.............

can i use a formula that calculate every next row.

Thanks in advance,

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

HTH
--
AP

quot;Aarifquot; gt; a écrit dans le message de
...
gt; Hi,
gt;
gt; a1,a3,a5.......... =a1 a3 a5.............
gt;
gt; can i use a formula that calculate every next row.
gt;
gt; Thanks in advance,
gt;
gt; Aarif
gt;
gt;
Hi Ardus,

Thanks for giving attention to my problem but when i am using this formula
getting an value error and i am not so familier with excel formulas so dont
can understand how this formula actually works, this formula looks so
complecated to me,will you help me again to resolve the problem,

thanks again for replying,

Aarif

quot;Ardus Petusquot; wrote:

gt; =SUMPRODUCT(--(MOD(ROW(A1:A99),2)=1),A1:A99)
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;Aarifquot; gt; a Ãcrit dans le message de
gt; ...
gt; gt; Hi,
gt; gt;
gt; gt; a1,a3,a5.......... =a1 a3 a5.............
gt; gt;
gt; gt; can i use a formula that calculate every next row.
gt; gt;
gt; gt; Thanks in advance,
gt; gt;
gt; gt; Aarif
gt; gt;
gt; gt;
gt;
gt;
gt;

My formula is based on current row number. If row id odd, add the number,
else skip it.

Do you get a #VALUE result?

--
AP

quot;Aarifquot; gt; a écrit dans le message de
...
gt; Hi Ardus,
gt;
gt; Thanks for giving attention to my problem but when i am using this formula
gt; getting an value error and i am not so familier with excel formulas so
dont
gt; can understand how this formula actually works, this formula looks so
gt; complecated to me,will you help me again to resolve the problem,
gt;
gt; thanks again for replying,
gt;
gt; Aarif
gt;
gt; quot;Ardus Petusquot; wrote:
gt;
gt; gt; =SUMPRODUCT(--(MOD(ROW(A1:A99),2)=1),A1:A99)
gt; gt;
gt; gt; HTH
gt; gt; --
gt; gt; AP
gt; gt;
gt; gt; quot;Aarifquot; gt; a écrit dans le message de
gt; gt; ...
gt; gt; gt; Hi,
gt; gt; gt;
gt; gt; gt; a1,a3,a5.......... =a1 a3 a5.............
gt; gt; gt;
gt; gt; gt; can i use a formula that calculate every next row.
gt; gt; gt;
gt; gt; gt; Thanks in advance,
gt; gt; gt;
gt; gt; gt; Aarif
gt; gt; gt;
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;
One or more of the cells in your sum range is probably producing the #VALUE!
error, which is being mirrored (returned) by Ardus' formula.

Make sure there are no errors in your original data.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

quot;Aarifquot; gt; wrote in message
...
Hi Ardus,

Thanks for giving attention to my problem but when i am using this formula
getting an value error and i am not so familier with excel formulas so dont
can understand how this formula actually works, this formula looks so
complecated to me,will you help me again to resolve the problem,

thanks again for replying,

Aarif

quot;Ardus Petusquot; wrote:

gt; =SUMPRODUCT(--(MOD(ROW(A1:A99),2)=1),A1:A99)
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;Aarifquot; gt; a écrit dans le message de
gt; ...
gt; gt; Hi,
gt; gt;
gt; gt; a1,a3,a5.......... =a1 a3 a5.............
gt; gt;
gt; gt; can i use a formula that calculate every next row.
gt; gt;
gt; gt; Thanks in advance,
gt; gt;
gt; gt; Aarif
gt; gt;
gt; gt;
gt;
gt;
gt;
I am very sorry, wested your valuable time i was discribed my problem to you
people wrongly actually i want sum of every next field.

a1 a2 a3 a4
10 15 10 5 ..........

I want sum of a1 amp; a3 skipping a2,a4........... and also want su of a2 amp;
a4 skipping a1,a3

sorry again, i want a formula that can give me sum of every next field.

thanks,
Aarif
quot;RagDyeRquot; wrote:

gt; One or more of the cells in your sum range is probably producing the #VALUE!
gt; error, which is being mirrored (returned) by Ardus' formula.
gt;
gt; Make sure there are no errors in your original data.
gt; --
gt;
gt; HTH,
gt;
gt; RD
gt; ================================================== ===
gt; Please keep all correspondence within the Group, so all may benefit!
gt; ================================================== ===
gt;
gt; quot;Aarifquot; gt; wrote in message
gt; ...
gt; Hi Ardus,
gt;
gt; Thanks for giving attention to my problem but when i am using this formula
gt; getting an value error and i am not so familier with excel formulas so dont
gt; can understand how this formula actually works, this formula looks so
gt; complecated to me,will you help me again to resolve the problem,
gt;
gt; thanks again for replying,
gt;
gt; Aarif
gt;
gt; quot;Ardus Petusquot; wrote:
gt;
gt; gt; =SUMPRODUCT(--(MOD(ROW(A1:A99),2)=1),A1:A99)
gt; gt;
gt; gt; HTH
gt; gt; --
gt; gt; AP
gt; gt;
gt; gt; quot;Aarifquot; gt; a Ãcrit dans le message de
gt; gt; ...
gt; gt; gt; Hi,
gt; gt; gt;
gt; gt; gt; a1,a3,a5.......... =a1 a3 a5.............
gt; gt; gt;
gt; gt; gt; can i use a formula that calculate every next row.
gt; gt; gt;
gt; gt; gt; Thanks in advance,
gt; gt; gt;
gt; gt; gt; Aarif
gt; gt; gt;
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt;
gt;
gt;

To sum even row numbers: ( A2,A4, A6,...)
=SUMPRODUCT(--(MOD(ROW(A1:A99),2)=01),A1:A99)

To sum odd row numbers: (A1, A3, A5, ...)
=SUMPRODUCT(--(MOD(ROW(A1:A99),2)=1),A1:A99)
--
HTH
--
AP

quot;Aarifquot; gt; a écrit dans le message de
...
gt; I am very sorry, wested your valuable time i was discribed my problem to
you
gt; people wrongly actually i want sum of every next field.
gt;
gt; a1 a2 a3 a4
gt; 10 15 10 5 ..........
gt;
gt; I want sum of a1 amp; a3 skipping a2,a4........... and also want su of a2
amp;
gt; a4 skipping a1,a3
gt;
gt; sorry again, i want a formula that can give me sum of every next field.
gt;
gt; thanks,
gt; Aarif
gt; quot;RagDyeRquot; wrote:
gt;
gt; gt; One or more of the cells in your sum range is probably producing the
#VALUE!
gt; gt; error, which is being mirrored (returned) by Ardus' formula.
gt; gt;
gt; gt; Make sure there are no errors in your original data.
gt; gt; --
gt; gt;
gt; gt; HTH,
gt; gt;
gt; gt; RD
gt; gt; ================================================== ===
gt; gt; Please keep all correspondence within the Group, so all may benefit!
gt; gt; ================================================== ===
gt; gt;
gt; gt; quot;Aarifquot; gt; wrote in message
gt; gt; ...
gt; gt; Hi Ardus,
gt; gt;
gt; gt; Thanks for giving attention to my problem but when i am using this
formula
gt; gt; getting an value error and i am not so familier with excel formulas so
dont
gt; gt; can understand how this formula actually works, this formula looks so
gt; gt; complecated to me,will you help me again to resolve the problem,
gt; gt;
gt; gt; thanks again for replying,
gt; gt;
gt; gt; Aarif
gt; gt;
gt; gt; quot;Ardus Petusquot; wrote:
gt; gt;
gt; gt; gt; =SUMPRODUCT(--(MOD(ROW(A1:A99),2)=1),A1:A99)
gt; gt; gt;
gt; gt; gt; HTH
gt; gt; gt; --
gt; gt; gt; AP
gt; gt; gt;
gt; gt; gt; quot;Aarifquot; gt; a écrit dans le message de
gt; gt; gt; ...
gt; gt; gt; gt; Hi,
gt; gt; gt; gt;
gt; gt; gt; gt; a1,a3,a5.......... =a1 a3 a5.............
gt; gt; gt; gt;
gt; gt; gt; gt; can i use a formula that calculate every next row.
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks in advance,
gt; gt; gt; gt;
gt; gt; gt; gt; Aarif
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;