Need help with a complex formula
Attempting to write a formula in a sheet summary field. Is it possible to write a formula that looks for particular rows based on the text value in one column, and then get the AVG of the numbers in a different column on those selected rows?
(ie. If the value in column Task is "Work Order Received", find the average of the Duration column on those rows across all projects on the sheet)
I've tried a bunch of different variations and keep getting different errors. Anyone ever written a successful formula like this?
@Paul Newcome , I will never not tag you in formula questions LOL
Kelly L. Gabel
Help Article Resources
Check out the Formula Handbook template!