VLOOKUP in VB...I think!

[redspanna]

Hi all

Is there a way to do this using VB.....

Search through column A in sheet 1 to find the name "Fred"
When "Fred" is found check the corresponding date in column B
If this date falls into the range 01Apr05-31Mar06 then count it.
Loop this until all rows through column A where "Fred" is found.
Place the total of times Fred and date is in range 01Apr05-31Mar06 into cell I2

thanks in advance

 

[Phanmore]

Have you considered using a sumproduct formula, opr countifs.

I'm using 2003, so I don't have countifs, but sumproduct seems to work.

=SUMPRODUCT(--($A$1:$A$90="Fred"),--($B$1:$B$90>38443),--($B$1:$B$90<38898))

 

[redspanna]

Yep, that does the trick...many thanks