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

Columns in an Excel Attachment Data Upload Auto Added to a Source Sheet
Hi, I am wondering if there is a solution for this scenario: I have a Data Shuttle data upload workflow to a Target Sheet that is updated when a new attachment is added. Question: is there a function/features/workaround like Data Shuttle, Bridge, or a combination of features so that if a new column is added to the Excel…
Do not have access to a sheet I created in another plan
I have downgraded to business but no longer have access to my sheet,i get an error 48,get licensing? How do I fix this? This is a customer contact form so i cant recreate it as the email has been sent?
No Admin Access on Sheet
I have been given access as an Admin to edit an existing sheet but cannot edit columns. I am a System Admin. I am a paid Member. I am able to edit information in the sheet but cannot add a column.