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; } } }

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

"Fields marked with an asterisk (*) are required." line on every form.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
Dynamic View Issue - Group Sharing
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…