LARGE function with IF

I'm trying to create a formula to show the "Nth" highest value for a set of data but only if it meets a certain condition.

The values (to be used for the LARGE function) are either WON or PENDING. I would like to create a formula that indicates the "Nth" highest value but only look at the valies that are "PENDING".

Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!