error handling in excel

[arnab0711]

Hi,
I have this excel sheet where in cells e18:I18 there is a formula which returns an #NA if data is not found,I have tried with iferror but its not working should I try with ISerror or ifblank because I want a '0' if data is not found.

[DGagnon]

you are on the right track, you just need to put a 0 at the end of your formula:

=IFERROR(MEDIAN(IF((MONTH($AG$4:$AG$32)=MONTH($C18))*(YEAR($AG$4:$AG$32)=YEAR($C18))*($AD$4:$AD$32=$D18),$AH$4:$AH$32-$AG$4:$AG$32)),0)