Need help with array function using MEDIAN and nested IF with boolean AND

THAT WORKED!!!! Thank you so much!

I do have a follow up question. It seems that the function above (and others using IF functions) take into account empty cells, which skew the results. The ones just using AVERAGEIFS do not. Is that correct?

I use the Data sheet repeatedly, pasting in new datasets frequently. There can be up to 50000 rows, but most often less. That's why I set the upper range to 50000. If empty cells are indeed skewing the calculations, how could I add some additional logic to skip any empty rows/cells in the range?

Thanks in advance!

EDIT: Clarification--sometimes I need to total items that are from Bob but NOT Type "Incident", so I use the <> operator instead. This is where I run into the empty cells issue, as <>Incident includes fields that are empty, apparently. Example:

{=MEDIAN(IF('TT Data'!B1:B50000<>"Incident",IF('TT Data'!A1:A50000="Bob",'TTR= Data'!C1:C50000))}