AverageIF or Avg(Collect) formulas

Deesa Dontamsetti · 2021-10-11 15:15:25

Hi All, I have multiple criteria and thus used the AVERAGEIF statement, however, this is not working cause this formula only limits to one criteria, and I need to add multiple criteria. For example, we are able to do this with COUNTIFS statement, however, there is not AVERAGEIFS statement. Since AVERAGEIF is not working…

Answers

Paul Newcome ✭✭✭✭✭✭

07/22/22

AVG(COLLECT(..........)) should work too and requires less typing (and less cell references if you are in danger of hitting those limits). Are you able to provide the AVG/COLLECT you were using that was causing the error?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Parent and child rows
Hello, I need assistance with managing parent and child rows in Smartsheet. How can I display a milestone as completed once all of its child rows are marked as 100% complete? For example, if I complete all the rows under Milestone 5, how can I set Milestone 5 to show 100%? Thank you in advance for your help.
text to columns
Hello. I'm looking to split out the following string to provide just the supervisor name and I've yet to figure out the formula.. thoughts on how I do that in a helper column? Thanks Supervisor | Approved by Little, Paul on 12/4/23 @ 11:42 AM |
Was there a change to how the "Modified" filter works
Hello - I am running into a weird filtering issue that I have not had before. We have a new sheet that gets updated each day. Today we imported data into a sheet and I have separate reports based on when the sheet was "modified" However not all the data is showing up.

AverageIF or Avg(Collect) formulas

Answers

Help Article Resources

Categories