I found this solution using this page and hints from a few other pages.

=FILTER([ExcelFile.xlsx]TabName!C2:C38,([ExcelFile.xlsx]TabName!C2:C38 <> "")*([ExcelFile.xlsx]TabName!D2:D38 = "Active"),"Nada")

It works with an array and filters it for the data in the array not being empty and being equal to "Active". If no cells meet these criteria, it returns "Nada".

Slightly counter-intuitive, "*" in the second term of the formula means AND, while "+" would mean OR. It should work constructed with AND(), OR(), NOT() etc., depending on how you need to filter the data.

A caveat is that the results spill down below the cell in which the formula is, so it may be best to use this formula at the top of a sheet with nothing below it in that column. Embedded into a longer formula, this shouldn't be an issue.

My need for this array filtering was to calculate a T.TEST(), so I needed a way to return a filtered array which T.TEST() could use to calculate means of that array, and all the rest. In this case, using AVERAGEIFS() wouldn't help.