Why? In Excel the default argument separator is comma (,) that we have missed here. This will return the same 'Few argument error'. So, will the below formula work? = SUMIF (A2:A10 " data-type="undefined" target="_blank">50') That is why we are getting ''You've Entered Too Few Arguments For This Function' error.Ĭase 2: But this is not the mistake that you can make. Hence the SUMIF function requires at least two arguments. The sum range is optional if the sum range and criteria range is the same.
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.
