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

Hello!

I could really use a hand with a frustrating set of formulas. Here's the setup. I have tabular data, such as:

Col A Col B Col C
Name Type Time
Bob Incident 30
Susan Request 10
Bob Incident 20
Dan Other 40

on a sheet called "TT Data." There are a few sets of calculations I need to perform. One is to calculate the Average and Median Time for all rows with Type "Incident". This I have been able to get, with the following formulas:
=AVERAGEIF('TT Data'!B1:B50000, "=Incident", 'TT Data'!C1:C50000)
{=MEDIAN(IF('TT Data'!B1:B50000="Incident",'TT Data'C1:C50000))}

So far so good (hopefully those formula are correct!). Now things get a little trickier, as I need to find the Average and Median Time for all rows that are Type “Incident” and Name “Bob”
Averageifs seems to work OK:

=AVERAGEIFS('TT Data'!C1:C50000,'TT Data'!B1:B50000,"=Incident",'TT Data'!A1:A50000,"=Bob" )

I’m running into trouble trying to use a logical AND operation in the array Median/nested IF function. Here is the formula I’m using:

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

Excel accepts the formula, and spits out a total, but I know it’s incorrect. Looking further, it appears that as soon as it encounters a row that does not meet the criteria, the total is always zero. To test, I limited the range to one that I knew included only those that meet the criteria, and the median result was correct. Why does this happen? Is there a better way to “AND” these criteria together?

Thank you very much for any advice!

Try nested IFs instead of AND

{=MEDIAN(IF('TT Data'!B1:B50000="Incident",IF('TT Data'!A1:A50000="Bob",'TTR= Data'!C1:C50000))}
Does that work for you?

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))}