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.

Find more posts tagged with

Formulas

Comments

Andrée Starå

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

Gordon

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!!

Andrée Starå

Happy to help!

Glad to hear that it works now!

A temporary glitch maybe, it happens!

Sign in to join the conversation!

Quick Links

Trending discussions

Information in a form populates specific cell.
Hello, Just investigating an idea. I'm building a staff register sheet. I'm curious to know if its possible to populate specific cells by the answers given in a form? So if, in a form, a staff member gives their name, the date and that they will be on leave, sick, training ect. Once the form is submitted, it will populate…
A multiple SUMIF function
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])
Missing column in Report if I use a formula
I'm not able to "view by" a field that I have in my sheets - Quarters (Q1, Q2, Q3, Q4) - in my report. I think it is because I have used a formula to calculate the quarters in my sheets. Does anyone know a way to get a formula based field on the dropdown for view by in my report?