SUMIF Question

ldavenportHAP

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)

Mary Royston

Hey @ldavenportHAP

You might want to try =SUMIF([Client]:[Client], contains("TRA", @cell), [Amount Due]:[Amount Due])

That should work, it not let me know :)

Mary Royston

Hey @ldavenportHAP

You might want to try =SUMIF([Client]:[Client], contains("TRA", @cell), [Amount Due]:[Amount Due])

That should work, it not let me know :)

ldavenportHAP

Yes! @Mary Royston thank you so much!