Hey everyone,

I need to count the number of instances a row meets a few requirements.

For example, the row contains the following data:

A B C D
1|| Active Mechanic 2/28/2005 9/9/2005
2|| Terminated Mechanic 9/1/2004 8/19/2005
3|| Leave Janitor 7/27/1991 5/16/2005

I want to count all those who are A) Terminated, B) a Mechanic, and
D)between 1/1/2005 and 12/31/2005. The results from the above data
should be "1".

Any advice?

I'd like to use this array [ctrl-shift-enter] but can't figure out how
to get date ranges in there:

=SUM((A1:D3="Terminated")*(B1:B3="Mechanic"))

TIA!