Make sure that all number arguments are within the range that the function expects. #NESTED CRITERIA Cause You’ve nested criteria in a SUMIF or COUNTIF function. Resolution Use SUMIFS or COUNTIFS instead as you can include multiple criteria without nesting. #NO MATCH Causes The VLOOKUP or MAT...