Welcome!

SUMIFS returning #incorrect Argument Set... I can't seem to figure it out..

JimC2018

=SUMIFS(CATEGORY:CATEGORY, QUESTION4, [OverallTime (Minutes)]:[OverallTime (Minutes)])

this works fine...

=COUNTIFS(CATEGORY:CATEGORY, QUESTION4)

Please help

Find more posts tagged with

Comments

Paul Newcome

Can you provide a screenshot or more details as to what is in each column?

p_bureau

Hi,

what do you try to achieve ? I'm pretty sure this one will work :

=SUMIFS([OverallTime (Minutes)]:[OverallTime (Minutes)],CATEGORY:CATEGORY, QUESTION4)

Best regards,

Paul.

JimC2018

Eventually I am needing to average, by category, the Overall Time (minutes). So, Have the count already, by category. I am now trying to Sum the minutes and then divide Minutes by count to get an average. I am sure there are better ways to do this, but just getting my feet wet with the formulas.

Smartsheet SUMIF.PNG

JimC2018

Thanks Paul. It works fine..

Paul Newcome

I am sure there are better ways to do this

You're actually right on the money with the best approach already.

=SUMIFS(Stuff) / COUNTIFS(More Stuff)

Unfortunately Smartsheet doesn't have an AVGIFS() function...

J. Craig Williams

Smartsheet's AVG IF looks like this:

=AVG(COLLECT(range-to-average, criterion-range-1, criterion-1))

Craig

Sign in to join the conversation!

Quick Links

Trending discussions

Capturing Cost Savings by the month
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
Automation to send Reminder @ 60d, 30d, etc
Hello team! Hope you all are having a wonderful holiday season. I am trying to set up an automation that will send an email reminder one time when Next Update Date = 60 days, then another automation at 30d, etc. The key is I only want it to send the reminder one time when Next Update threshold is reached. Is this possible?…
How do I share a report document to an external client without having to give full access to the doc
Has anyone found a workaround for sharing Smartsheet reports externally without giving access to internal data? I currently have to download the data and transfer it onto excel to create a pivot table for our client and I want to find an easier way to do so. I also already create a dashboard for our client, but I wanted…