I did try using to F4 button, however it gave me the same results.

I tried to trouble shoot the equation by changing the column reference from $AB to just $A and it worked.

I am trying to reference a row of cells on a separate tab.