SUMIFS formula returning #INCORRECT ARGUMENT SET: order of Range & Criteria?

Lisa Purser

Can someone help me. I currently have a formula that counts pending

=COUNTIFS({STATUS}, "Pending", {SECTOR}, "Business/Chambers of Commerce")

I need it to count if the column contains pending OR scheduled

Andrée Starå

@Lisa Purser

Hi Lisa,

Try something like this.

=COUNTIFS({Status}; OR(@cell = "Pending"; @cell = "Scheduled"); {Sector}; "Business/Chambers of Commerce")

The same version but with the below changes for your and others convenience.

=COUNTIFS({Status}, OR(@cell = "Pending", @cell = "Scheduled"), {Sector}, "Business/Chambers of Commerce")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma."

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!