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

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.

 

 

 

 

 

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