Counting multiple criteria involving dates
 

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 the

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

TIA!

Counting multiple criteria involving dates
 

{=SUM((DD!A3:DD!A945="Terminated")*(DD!D3:DD!D945= "Mechanic")*(DD!J3:DD!J945DATE(C1,1,1))*(DD!J3:DD !J945<DATE(C1,12,31)))}

Got it, thanks anyway:)

Counting multiple criteria involving dates
 

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