If your SUMIF criteria contains errors, Excel will return a #VALUE! error in the cell containing the formula.