What are common mistakes when using wildcards in SUMIF that lead to #VALUE! errors?

When using wildcards like '*' or '?' in SUMIF criteria, ensure they are enclosed in double quotes (e.g., "A*"). A #VALUE! error might occur if the wildcard is not properly quoted, or if you try to use a wildcard to match a numeric value that Excel cannot coerce properly. For example, trying to use `*` to match a number that is stored as text might fail.