I am trying to count the amout of tickets in a certain region that are of a Sev1 level and <24 hrs. old, but can't seem to get the function to work for me. Below is the function I am trying.
=SUMPRODUCT((Report!H2:H89="SW")*(Report!C2:C89<=24)*(Report!D2:D89=1),Report!A2:A89)
I am hitting Shift+Ctrl+Enter.
What I recieve is a 0 even though I know there is tickets fitting those conditions.
Ticket # Hours Open Severity Region
1 4.7 1 SW
Any ideas would be great..
Thanks.
Bookmarks