Counting multiple criteria involving dates

[S Davis]

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((A13="Terminated")*(B1:B3="Mechanic"))

TIA!

 

[S Davis]

{=SUM((DD!A3D!A945="Terminated")*(DD!D3D!D945="Mechanic")*(DD!J3D!J945>DATE(C1,1,1))*(DD!J3D!J945<DATE(C1,12,31)))}

Got it, thanks anyway

 

[S Davis]

Sorry, that last reply had the year "2005" at c1, and started at A3,
unlike the above example. Cheers