COUNTIF and VLOOKUP in VAB

[Davidkerr7]

Hi, i need help counting the number of time a value appears. Programmed with VBA
Here is an examples.

[/URL][/IMG]

Exercise 1
So let say i need to count the number of time "Finished" Shows up based on the month.
Here is an example of what I'm trying to achieve

[/URL][/IMG]

I'm not sure what the ideal approach would be but i'm guessing it would require a combination of an IfStatement, Vlookup and CountIF.
Unless there is a better approach.

if anyone can plz help.
Thanks

 

[ctd2015]

Why don't you simply use a pivot table?

 

[Noodleski]

Is this homework?

I ask, because there's 'exercise 1' in your OP.

 

[Davidkerr7]

I found that CountIFS command gets the job done quite well.
but it don't seem to like to do ">=" or "<=" when dealing with Dates in VBA.
anyone know a why ?