sum formula help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Aarif - 18 Mar 2006 15:48 GMT

Hi,

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

can i use a formula that calculate every next row.

Thanks in advance,

Aarif

Reply to this Message

Ardus Petus - 18 Mar 2006 16:09 GMT

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

HTH
--
AP

> Hi,
>
[quoted text clipped - 5 lines]
>
> Aarif

Reply to this Message

Aarif - 18 Mar 2006 17:27 GMT

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

> =SUMPRODUCT(--(MOD(ROW(A1:A99),2)=1),A1:A99)
>
[quoted text clipped - 11 lines]
> >
> > Aarif

Reply to this Message

Ardus Petus - 18 Mar 2006 18:10 GMT

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

> Hi Ardus,
>
[quoted text clipped - 22 lines]
> > >
> > > Aarif

Reply to this Message

RagDyeR - 18 Mar 2006 18:26 GMT

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.

Signature

HTH,

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

> =SUMPRODUCT(--(MOD(ROW(A1:A99),2)=1),A1:A99)
>
[quoted text clipped - 13 lines]
> >
> > Aarif

Reply to this Message

Aarif - 20 Mar 2006 15:58 GMT

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 & a3 skipping a2,a4........... and also want su of a2 &
a4 skipping a1,a3

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

thanks,
Aarif

> One or more of the cells in your sum range is probably producing the #VALUE!
> error, which is being mirrored (returned) by Ardus' formula.
[quoted text clipped - 30 lines]
> > >
> > > Aarif

Reply to this Message

Ardus Petus - 20 Mar 2006 17:02 GMT

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

> 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.
[quoted text clipped - 44 lines]
> > > >
> > > > Aarif

Reply to this Message