Excel Formula

Hi there,

I have the below formula

=IFERROR(MEDIAN(IF(Works!$B$1:$B$6568=DS7,IF(Works!$Z$1:$Z$6568>0,Works!$Z$1:$Z$6568))),0)

that I simply copied from a report that I do each month, the only difference this month is I have added an extra column I have changed the formula to ensure it still picks up the correct cell reference but for some reason it does not work.

When I look into the previous month's formula it shows the curly brackets {} around the formula, but if I F2 then they aren't there, so the formula looks like:
{=IFERROR(MEDIAN(IF(Works!$B$1:$B$5036=DS4,IF(Works!$Y$1:$Y$5036>0,Works!$Y$1:$Y$5036))),0)}

I'm not sure why it doesn't work this month, I am wondering if it is to do with a formatiing of the sheet where the data comes from or something wrong with my formula.

Any help from anyone would be amazing.

Thankyou very much.