formula to count certain cell value based on date range

Hi. My last thread was deleted, probably because my subject was not concise enough.

I need help with a formula. Here's what I'm wanting to do:

I have dates in Column E
I have pass/fail values in Column AL

What I want to do is be able to count the number of cells with the value "pass" in column AL based on a range of dates in column E.

Thank you! I'll go try it now!!

Thanks for your help but it doesn't work. We're all puzzling over this one at the office!

I was entering the dates in the forumla and replacing the X1, X2... It was returning a value of 0 no matter what date range I put in.

I upgraded to Excel 2007 and this formula works perfectly:

=COUNTIFS(E:E,"<3/24/2007",E:E,">3/18/2007",AL:AL,"Pass")

Not sure why I couldn't get yours to work. But this on works great. I don't know if the 'COUNTIFS' function was in 2003 but in 2007, it allows you to specify mutliple ranges and criteria, unlike COUNTIF that only allowed one criteria.

Thanks for your help! Hope my posting back could help someone else too!