Re: Calculation of row count

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 ?
> > >
> >
> >
> >


.