Sign in to join the conversation:
=SUMIFS(CATEGORY:CATEGORY, QUESTION4, [OverallTime (Minutes)]:[OverallTime (Minutes)])
this works fine...
=COUNTIFS(CATEGORY:CATEGORY, QUESTION4)
Please help
Can you provide a screenshot or more details as to what is in each column?
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.
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.
Thanks Paul. It works fine..
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...
Smartsheet's AVG IF looks like this:
=AVG(COLLECT(range-to-average, criterion-range-1, criterion-1))
Craig
Hello! I’ve noticed for a LONG time that when I change the name of a column in a source sheet, the corresponding column in reports breaks, which then causes dashboard widget charts (that rely on those reports) to fail. Is there a way to: Prevent this issue when renaming columns? Fix existing reports and dashboards without…
Dear All, my account was suspended for a long period in which my sheets were deleted. I renewed my account and asked technical support if my sheets could be recovered. I received this message below, but I do not seem to get a reply back afterwards and still do not have my sheets recovered. Thanks for…
I been trying to access to my worksheets but it shows up the next error Anyone know how to solve this?
