need help- count w/ multiple criteria

J

Julz

Here's a snippet of my data source

TEAM MANAGED OPENED TROUBLE_TICKET_ID
MAG Y 4/10/2004 5:30 1253992
MAG Y 4/13/2004 5:18 1253984
MAG Y 4/12/2004 5:08 1253979
MAG Y 4/11/2004 14:10 1253953
MAG N 4/13/2004 3:59 1253947
PWS N 4/13/2004 3:33 1253926
MAG N 4/13/2004 2:59 1253883
IPT N 4/13/2004 2:45 1253871
MAG N 4/13/2004 2:33 1253865
IPT N 4/13/2004 2:23 1253844

Needing a formula to count the number of times
team = MAG & managed= Y & opened= >24 hours

thanx in advance,
~julz
 
J

Jason Morin

=SUMPRODUCT((A2:A11="MAG")*(B2:B11="Y")*((NOW()-LEFT(TRIM
(C2:C11),FIND(" ",TRIM(C2:C11),FIND(" ",TRIM(C2:C11))+1)-1)
*1)*24>24))

where Team = col. A, Managed = col. B, Opened Troub... =
col. C.

HTH
Jason
Atlanta, GA
 
Top