Sumproduct formula

Could someone assist me here :

When using sumproduct formula, eg :

=sumproduct(($A$1:$A$10=”china”)*($C$1:$C$10))

This is the total revenue in US dollars from China when comparing to 4 other countries.

Now in the c5 row, if accidentally we insert a say example “, then the sumproduct will show #value. is this a common weakness is sumprosuct that the dimension in column c has to be same or there ia a way to go about this. Please help