nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

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

Control center Project Redeployment
Hi All, We occasionally run into situations where the wrong dropdown value is selected in the intake sheet. The project is then provisioned through Control Center, and later the PM raises a request to correct it. My current process is: Locate the project in Control Center. Delete the provisioned project workspace. Control…
Sudden malfunctioning in notifications
Hello to all the community, my team is experiencing an issue with the notifications in Smartsheet. In the last hour the notifications started including only the placeholders of the columns, instead of the content of the related cell. I checked with the support and this could be related to changes in the workflow or in the…
Is there a way to upload an excel file to replace a current sheet?
I have a 6 column, 10,000+ row sheet that feeds into other sheets of data through vlookup formulas, that I update on a weekly basis with new information from an outside source. the columns stay the same but the row #'s vary. is there a way I can upload the new excel version of the data to automatically upload the existing…