Nested IF Function with Dates?

[queens123]

I've been looking at lots of forums and there seems to be a number of ways to tackle this problem, but none seem to be helping. My database looks something like this --->
----1--------2-------- 3
A Course ---Start Date ---Status
B PLH03---- 2010-04-02 ---Complete
C CPR1----- 2010-04-06 ---Complete
D CPR1 -----2010-05-01 ---Canceled
E CPR2 -----2010-04-12 ---Canceled

And it goes on and on...

Couple of questions -
How would I go about writing a formula to calculate the number of Courses that start in April 2010 and that have been Completed?

Also what formula would let me find the total number of CPR1 courses that start in April?

Any sort of help would be appreciated since I'm about to toss my computer across the room

 

[VoG]

Try

=SUMPRODUCT(--(MONTH(B2:B5)=4),--(E2:E5="Complete"))

and

=SUMPRODUCT(--(MONTH(B2:B5)=4),--(A2:A5="CPR1"))

 

[queens123]

Works like a charm, many thanks VoG.

Now what if I wanted to extend it so that I could find the number of completed CPR1 Courses for the month of April?

 

[VoG]

Try like this

=SUMPRODUCT(--(MONTH(B2:B5)=4),--(A2:A5="CPR1"),--(E2:E5="Complete"))