+ Reply to Thread
Results 1 to 5 of 5

You have entered too few arguments for this function

  1. 10-11-2019, 04:21 PM #1
    i.riyasrafi
    i.riyasrafi is offline
    Registered User
    Join Date
    10-11-2019
    Location
    India
    MS-Off Ver
    2007
    Posts
    2

    You have entered too few arguments for this function

    Hello, i have a excel(sheet1) 200 employees productivity data contains 500000 rows.

    In this employee name in - column d, pickup time in - column f, end time are the columns in - column e, break time in- column G (time gap of end time - pickup time)and dropdown list is - Column h

    I am trying to calculate the break time of specific employees used drop down list.

    My formula as follows.

    =SUMIFS(D2:D320000,H$3,G2:G320000,">00:15:00")

    But its showing a error says too fee arguments for this function

    I am trying to find a break time of a particular employee through drop down list.

    Pls suggest the right formula..
    Reply With QuoteRegister To Reply
  2. 10-11-2019, 04:27 PM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: You have entered too few arguments for this function

    There is no sum range, just two criteria ranges.

    =SUMIFS(sumrange,criteriarange,criteria,criteriarange,criteria)
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 10-11-2019, 04:37 PM #3
    i.riyasrafi
    i.riyasrafi is offline
    Registered User
    Join Date
    10-11-2019
    Location
    India
    MS-Off Ver
    2007
    Posts
    2
    Quote Originally Posted by AliGW View Post
    There is no sum range, just two criteria ranges.

    =SUMIFS(sumrange,criteriarange,criteria,criteriarange,criteria)
    Can you post some example formula for my query its useful for me
    Reply With QuoteRegister To Reply
  4. 10-15-2019, 08:14 PM #4
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,546

    Re: You have entered too few arguments for this function

    It appears that you are attempting to sum only the break times that are longer than 15 minutes for a particular employee.
    If that is the case try: =SUMIFS(G2:G320000,D2:D320000,H$3,G2:G320000,">00:15:00")
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
  5. 10-16-2019, 01:26 AM #5
    FDibbins
    FDibbins is online now
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: You have entered too few arguments for this function

    Quote Originally Posted by i.riyasrafi View Post
    Can you post some example formula for my query its useful for me
    Ali is showing you the syntax for how SUMIFS works. As she pointed out, you dont seem to have a sum range?

    This is the syntax again...
    =sumifs(sum-range, criteria1-range, criteria1, criteria2-range, criteria2...etc)
    where sum-range = the range you want to sum
    criteria-range = the range/ranges that contain the criteria to base the sum on
    criteria = what you want to base the sum on, eg date, name, model etc
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. You've entered too many arguments for this function
    By exced in forum Excel General
    Replies: 6
    Last Post: 11-30-2016, 11:57 AM
  2. How have I entered too many arguments for this function
    By mrdasi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-06-2015, 07:11 AM
  3. You've entered too many arguments for this function
    By jessrose in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-06-2014, 11:09 PM
  4. [SOLVED] You've entered to many arguments for this function????????
    By STU22 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-20-2014, 06:40 PM
  5. You've entered too many arguments for this function
    By sutharnehal in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-24-2012, 09:25 PM
  6. You've entered too many arguments for this function
    By leematthews in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-21-2011, 03:11 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1