So what if I write this formula:Ī SUMIF formula requires three arguments, the Criteria range, criteria and sum range. Then of course I will use the SUMIF function. Possible ScenariosĬase 1: For example, if I want to sum all the numbers in the range A2:A10 with a condition that the numbers should be greater than 50. This happens when you don't provide all the mandatory arguments to the a function in an Excel formula. You may have observed the 'You've Entered Too Few Arguments For This Function' error while using Excel.