Inconstant results within 'if' functions

Hello,
I have been creating a robust spreadsheet that relies heavily on 'if' functions, however I have encountered something strange and frustrating. Identical formula formattings are producing 2 different results.
Item 1:
=IF(AJ147="3",0,3)+IF(AM147="3",0,3)+IF(AP147="3",0,3)+IF(AS147="3",0,3)+IF(AV147="3",0,3)+IF(AY147="3",0,3)+IF(BB147="3",0,3)+IF(BE147="3",0,3)
This function is working correctly.
However, Item 2:
=IF(AJ150="3",0,3)+IF(AM150="3",0,3)+IF(AP150="3",0,3)+IF(AS150="3",0,3)+IF(AV150="3",0,3)+IF(AY150="3",0,3)+IF(BB150="3",0,3)+IF(BE150="3",0,3)
Is not producing the correct value.
I can modify item 2 to remove the quotation marks and it now works, but if I remove the quotation marks is item 1 it no longer works.
I am relying on a similar formula variation to apply to several hundred cells, but the inconsistency is causing major problems.
I have tried having the reference cells formatted both generally and as a number, same with the formula cells, and this changed nothing.
The reference cells also are formulas, but virtually identical as the above examples, and they have not demonstrated any challenges.
Can anyone provide insight into this issue?

Thank you!
This seems to have fixed the problem. I have not encountered problems in the past with text "numbers" over regular numbers and I would have assumed formatting the cells as a number would fix it, but removing quotations in the formulas leading to those cells seems to have worked.