software

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 quot;1quot;.

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((A13=quot;Terminatedquot;)*(B1:B3=quot;Mechanicquot;))

TIA!{=SUM((DD!A3D!A945=quot;Terminatedquot;)*(DD!D3D!D945= quot;Mechanicquot;)*(DD!J3D!J945gt;DATE(C1,1,1))*(DD!J3D !J945lt;DATE(C1,12,31)))}

Got it, thanks anywaySorry, that last reply had the year quot;2005quot; at c1, and started at A3,
unlike the above example. Cheers