SUMIF Question


im trying to play around with this formula and not getting what i need.

I want to sum "Amount Due" totals if the "client" is TRA

this is what i was trying but wasnt working

=SUMIF(Client:Client, HAS(@cell, "TRA"), Amount Due:Amount Due)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!