Collecting valued with IF Dependencies

Options
eLIZo
eLIZo ✭✭✭✭
edited 11/17/22 in Formulas and Functions

I'm stumped in trying to average the values in a column ( CMO Dispo) that meets the criteria of

  • CMO column - "Agilent"
  • DOM column - 2022 year

Current non-working formula: =AVG(COLLECT([CMO Dispo (Business Days)]:[CMO Dispo (Business Days)], MFG:MFG, ="Agilent", DOM:DOM, =YEAR(2022, 1, 1)))

I'm pretty sure its not working because there are some error cells in my CMO Dispo column, but I don't know how to get it to skip cells with a error code.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!