Hey,
I have a table where Column B is an ID number with no formula in it and I want to reference that ID for another formula. However, If I reference Cell B3, I get an incorrect number. However, If I reference "228" then I get the correct answer.

Cell B3 is 228. General Format
This formula returns the wrong answer. This returns 1 but it should be returning 18
=SUMPRODUCT(--((Raw[DateNew2]*1)>=TODAY()-(DAY(TODAY()-1)*(Raw[StoresNew2]=B3))))

This formula gives the correct answer
=SUMPRODUCT(--((Raw[DateNew2]*1)>=TODAY()-(DAY(TODAY()-1)*(Raw[StoresNew2]="228"))))

Anyone have any suggestions? I have played with all formats to be number/text/general but that didn't work.