One person types “N/A”, another leaves the cell blank, a third writes “n/a “ with a trailing space. A date arrives as text. A region shows up as “North”, “north”, and “Norte”. Every formula downstream is correct, and the totals are still wrong.