Array Function No Longer Working

[wmurphy8989]

Hi everyone - I have an array formula that was initially working but now shows the NA error in every cell where it is written. My formula is as follows:

=MEDIAN(IF(Filled!Z:Z>4,IF(Filled!G:G=E3,IF(Filled!B:B>=E5,IF(Filled!B:B<=G5,IF(Filled!K:K<18,Filled!Z:Z))))))

E5 and G5 are cells with dates (looking for the median between two dates)

E3 is a cell that has data validation with a list of names (need the data specific to a name)

Can anyone help? Thanks!

 

[wmurphy8989]

Figured this out - out of the thousands of rows, there was one single NA in the name column.