Receiving #INVALID OPERATOR when using AVERAGEIF
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.
Help Article Resources
Check out the Formula Handbook template!