Hi Mikeu25,

Welcome to the forum.

Just checked that Formula is working even without double quotes..

See attachment.
sumif issue Mikeu.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>