Re: Calculation of row count
- From: "Alur" <Alur@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 1 Jul 2005 21:32:01 -0700
I used
Range("A7").Formula = "=Sumproduct(--(A2:A6=1),--(Year(Y2:Y6)=2005))"
It translated
and in the cell A7 the result is 0. Why?
"Tom Ogilvy" wrote:
> in the immediate window of the vbe, put in a command like this
>
> Range("AA1").Formula = "=Sumproduct(--(A2:A6=1),--(Year(Y2:Y6)=2005))"
>
> then go to the end of that command and hit enter to execute it.
>
> Look in cell AA1 and you should see the translated command.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Alur" <Alur@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:C9BA77FD-782C-49B8-B6BB-98453868E0A6@xxxxxxxxxxxxxxxx
> > Where can i find the same functions (like sumproduct)
> > in other languages ?
> >
> > "Tom Ogilvy" wrote:
> >
> > > =Sumproduct(--(A2:A6=1),--(Year(Y2:Y6)=2005))
> > >
> > > --
> > > Regards,
> > > Tom Ogilvy
> > >
> > >
> > > "Alur" <Alur@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > > news:BF83B630-8D27-48BD-AA67-3AD4CEE34620@xxxxxxxxxxxxxxxx
> > > > I have two columns and five rows.
> > > > A Y
> > > > 1 11.01.2005
> > > > 1 12.06.2004
> > > > 3 10.06.2005
> > > > 4 15.03.2005
> > > > 1 10.01.2005
> > > >
> > > > Condition: A=1 and Y=2005 (this year)
> > > > Requirement: to find the amount of rows with the help of some formula
> > > > (= and so on)
> > > > How is it possible to calculate that amount ?
> > > >
> > >
> > >
> > >
>
>
>
.
- Follow-Ups:
- Re: Calculation of row count
- From: Dave Peterson
- Re: Calculation of row count
- References:
- Re: Calculation of row count
- From: Alur
- Re: Calculation of row count
- From: Tom Ogilvy
- Re: Calculation of row count
- Prev by Date: Re: YAQ (Yet another question)
- Next by Date: Re: Export two overlapping charts to .gif
- Previous by thread: Re: Calculation of row count
- Next by thread: Re: Calculation of row count
- Index(es):
Relevant Pages
|
