"You've Entered Too Few Arguments For This Function" Excel Error and How to Solve It?

You may have observed the "You've Entered Too Few Arguments For This Function" error while using Excel. This happens when you don't provide all the mandatory arguments to the a function in an Excel formula.

Possible Scenarios 

Case 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. Then of course I will use the SUMIF function. So what if I write this formula:

 

=SUMIF(A2:A10)

 

Will this work? No

A SUMIF formula requires three arguments, the Criteria range, criteria and sum range. The sum range is optional if the sum range and criteria range is the same. Hence the SUMIF function requires at least two arguments. We have provided only 1. That is why we are getting ""You've Entered Too Few Arguments For This Function" error.

Case 2: But this is not the mistake that you can make. So, will the below formula work?

=SUMIF(A2:A10  ">50")

Normally, this will not work either. This will return the same "Few argument error". Why? In  Excel the default argument separator is comma (,) that we have missed here. It happens sometimes that we miss the list separator in formulas or use a different list separator which is not accepted in Excel. 

Excel will treat the above formula arguments as one argument. Hence again we have not supplied enough arguments to the function, resulting in error.

So the correct formula will be,

=SUMIF(A2:A10,">50")

Case 3: Will the above formula work? Normally, yes. It will work. But in special cases, it might not work.

If your computer has a different list separator like semicolon, colon or even space, this formula might not work. See the image below. I have all the required arguments but I am getting an unexpected error.

This is because I have changed the list separator in my system. To change the list separator on your computer, do this.

  • Open the running window (you can use Windows+R shortcut key). Here, type "intl.cpl" (without quotes) and hit the enter key.
  • A regional window will open. In the bottom right corner of the window you will see a button "Additional Settings. Click on it.
  • Now go to the list separator text box and write "," comma or reset to default.
    This will make Excel recognize the comma as a list separator and you will not get the "Too few arguments error".

    Now if you try the same formula, it will not throw any error and you will get the correct answer.

    So yeah guys, this is how you can make the "Too Few Arguments" error go. I hope this article will help you. If you have any questions or doubts regarding this topic or have a query related to Excel/VBA, please ask in the comments section below I will be happy to know them.

    Related Articles:

    What To Do If Excel SUMIF Is Not Working? The SUMIF function is a useful function when it comes to summing up values based on some given condition. But there are times when you will face some difficulties working with the function. You will notice that the SUMIF function is not working properly or returning inaccurate results.

    13 Methods of How to Speed Up Excel | Excel is fast enough to calculate 6.6 million formulas in 1 second in ideal conditions with normal configuration PC. But sometimes we observe excel files doing calculations slower than snails. There are many reasons behind this slower performance. If we can identify them, we can make our formulas calculate faster.

    Center Excel Sheet Horizontally and Vertically on Excel Page : Microsoft Excel allows you to align worksheet on a page, you can change margins, specify custom margins, or center the worksheet horizontally or vertically on the page. Page margins are the blank spaces between the worksheet data and the edges of the printed page

    Split a Cell Diagonally in Microsoft Excel 2016 : To split cells diagonally we use the cell formatting and insert a diagonally dividing line into the cell. This separates the cells diagonally visually.

    How do I Insert a Check Mark in Excel 2016 : To insert a checkmark in Excel Cell we use the symbols in Excel. Set the fonts to wingdings and use the formula Char(252) to get the symbol of a check mark.

    How to disable Scroll Lock in Excel : Arrow keys in excel move your cell up, down, Left & Right. However, this feature is only applicable when Scroll Lock in Excel is disabled. Scroll Lock in Excel is used to scroll up, down, left & right your worksheet not the cell. This article will help you with how to check scroll lock status and how to disable it?

    What to do If Excel Break Links Not Working : When we work with several excel files and use formulas to get the work done, we intentionally or unintentionally create links between different files. Normal formula links can be easily broken by using the break links option.

    Popular Articles:

    50 Excel Shortcuts to Increase Your Productivity | Get faster at your task. These 50 shortcuts will make you work even faster on Excel.

    How to use Excel VLOOKUP Function| This is one of the most used and popular functions of excel that is used to look up value from different ranges and sheets.

    How to use the Excel COUNTIF Function| Count values with conditions using this amazing function. You don't need to filter your data to count specific values. Countif function is essential to prepare your dashboard.

    How to Use SUMIF Function in Excel | This is another dashboard essential function. This helps you sum up values on specific conditions

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube