Conditional Median Formula

I have two columns of data for 1,472 data samples: Column A has numerical identifiers for job types and those numbers are 1 through 29. Column B has elapse times to complete those ID #'s in Column A. I have a table set up with 29 rows for each of the Job ID, 1 through 29 and those ID's are in column A. In the same table in column B, I've placed a conditional median formula that SHOULD calc the median time for each Job ID found in the data table of 1,472 entries. Here's the formula I'm using which I actually found here in another thread:

=MEDIAN(IF((DATA!$A:$A=1),DATA!$B:$B))

Unfortunately, I get zero values for all the Job ID numbers. All number formats are correct.

What am I doing wrong?

That formula should work.....but you need to confirm with CTRL+SHIFT+ENTER, have you done that?

If you have the formula in a cell then press F2 key to select formula then hold down CTRL and SHIFT keys and press ENTER....curly braces like { and } should appear around the formula in the formula bar.

You need to repeat the process if you change or re-enter the formulas.....but if you have a range of them you need to do it for the first one only...and then copy that one as required.

Better to restrict the range because using the whole column can be slow, e.g. use something like

=MEDIAN(IF(DATA!$A2:$A1500=1,DATA!$B2:$B1500))

That did it. I did have to re-enter the formula and confirm each of the 29 Job ID's, but luckily that's all I had to do. Thanks!