=COUNTIFS(Today!F:F,VLOOKUP(I12,Data!B1:F23,4,FALSE),Today!AH:AH,TRUE,Today!Q:Q,"Resolved")+COUNTIFS(Today!F:F,VLOOKUP(I12,Data!B1:F23,4,FALSE),Today!AH:AH,TRUE,Today!Q:Q,"Closed")
This is so long and ugly, but it was the only way I could get it working.
Note the plus sign in the middle; I'm just repeating the whole thing again...
I tried all sorts of syntax but could not get it working with the OR operator...
:-) Hoping for some help!
Bookmarks