Receiving #INVALID OPERATOR when using AVERAGEIF

Options

Hello,

I'm trying to average the value of Opportunity Age (Days) in a cell when Sales Stage contains "Won".

I'm receiving an #INVALID OPERATOR for the following:

=AVERAGEIF([Opportunity Age (Days)]:[Opportunity Age (Days)], [Sales Stage]:[Sales Stage], (CONTAINS("Won", @cell)))

Any tips you could provide would be greatly appreciated - thank you.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!