median if not functioning. Returning 0

Hi there,

I am testing out a median if formula, but it is partially working. Please see the attached.

Under "reporting" sheet, I have

=MEDIAN(IF((original!B:B=A1)*(original!C:C=B1),original!A:A))

When I hit enter, it returns 0 even though it is supposed to return the actual median value of the range specified based on the condition.

original B:B is the period column and the original c:c is the site column. It is returning 0 somehow, and I"m not sure where I have it wrong.

Could anybody help?

Thank you