If any cell range passed as an argument contains a reference concatenation operator (~), then SUMIFS reports an invalid argument error (Err:502).