It should affect your formula especially since you're using COUNT and not COUNTA. See if you can reproduce it on an example spreadsheet that you can upload.
The cell could be formatted not to show zeros in which case it would still be counted, just not show anything.