Excel 2007 : COUNTIFS with multiple criteria generates a zero value

[usurrao]

My formula to count the number of employees just based on date seems to work but if I use multiple criteria I get an incorrect number - see highlighted cell in sheet titled Calculations(2).
I need to calculate based on Active status, hourly or salary and before the date in Col A of sheet titled Calculations(2)
I am trying to add up total compensation based on the same parameters of Active status, Function (col A) and whether salary or hourly. I am able to get the sum if all data is included (whether active or not) but not if I include any additional parameters.
Thanks in advance,
USurrao

[romperstomper]

The formula should be:
=COUNTIFS('Employee Data'!$C$3:$C$20,"<"&A3,'Employee Data'!$I$3:$I$20,"=Active",'Employee Data'!$M$3:$M$20,"=Hourly")

[usurrao]

Thanks a million, it worked perfectly.