Re: Same row different Answer.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Steved <Steved@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 21 Jul 2005 17:34:02 -0700

Thankyou Govind, I put in COL and it did not work, I should have known better,
Thanks to you another lesson learnt.

Cheers.

"Govind" wrote:

> Hi,
>
> Try
>
> =IF(SUM((IF(MOD(COLUMN(C6:AA6),3)=0,C6:AA6)))=0,"",SUM((IF(MOD(COLUMN(C6:AA6),3)=0,C6:AA6))))
>
> with Ctrl+shift+enter.
>
> If not, let me know more detail about what you are trying to do.
>
> Govind.
>
>
> Steved wrote:
>
> > Hello from Steved
> >
> > =C6+F6+I6+L6+O6+R6+U6+X6+AA6 the sum = 22645 which is correct.
> >
> > =IF(SUM((IF(MOD(ROW(C6:AA6),3)=0,C6:AA6)))=0,"",SUM((IF(MOD(ROW(C6:AA6),3)=0,C6:AA6)))) = 25484 which is wrong.
> >
> > Please what is required for the above to make it correct.
> >
> > Thankyou.
>
.

References:
- Same row different Answer.
  - From: Steved
- Re: Same row different Answer.
  - From: Govind

Prev by Date: Re: datevalue
Next by Date: Re: problem with #value!/zero
Previous by thread: Re: Same row different Answer.
Next by thread: calculating term of financial transaction
Index(es):
- Date
- Thread