MAXIFS - can't find alternative

I have an formula I'm trying to translate from an Excel sheet to Smartsheet. As MAXIFS does not seem to be supported, I've tried a few other suggestions I found in the community board and can't seem to make it work.

I need the formula to look to see if the Program matches and the Model Name matches, and if so return the max value from the Sleeve Model column.

For example above row 3 and 4 have a matching Program name and matching Model Name, so I want it to return the highest number in the Sleeve Model column (which is 138888.88889).

You can see the last formula I tried that gives me a Divide by Zero error. I've also tried a few other things and just can't seem to make it work.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!