Formula Error - Sumifs
Hello,
I'm trying to build out a SUMIFS formula that adds up timesheet data from a separate data sheet using 4 criteria: employee name, project code, start date and end date. The formula works fine if I don't have criteria for project code. As soon as I add another criteria to match the client code, I get an #INCORRECT ARGUMENT SET error.
Here's the formula I wrote:
=SUMIFS({Timesheet Detail Hours}, {Timesheet Detail Client Code}, [Client Code]@row, {Timesheet Detail EE Number}, [Employee No]@row, {Timesheet Detail Date}, >=[Start Date]@row, {Timesheet Detail Date}, <=[End Date]@row)
The external Timesheet detail sheet being referenced is a flat data table. The client code is a 12-character alphanumeric code consisting of ABC001.ABC01 format, except certain records (rows) have client codes in the external sheet formatted as ABC001.0
Any help or insights on what I may be doing wrong is greatly appreciated.
Comments
-
Hi Gordon,
Are all ranges the same length?
More info about the error:
#INCORRECT ARGUMENT SET
Cause
This error is presented under the following circumstances:
- For functions that take two ranges: The range sizes don’t match for the function.
- The function is missing an argument.
- There is an extra function in the argument.
Resolution
Correct the range size or arguments, adding or removing arguments in the formula.
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Yes, I believe all the ranges are the same length, since when I created the external references, they were to the entire column in the external sheet.
However, I just opened the sheet with the SUMIFS formula again this morning and the error is gone. I didn't do anything to the external sheet. Weird...
Thanks!!
-
Happy to help!
Glad to hear that it works now!
A temporary glitch maybe, it happens!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!