Sum If Condition is true

[travismittel2]

Hi,

I am working on a simple budget app and I need some help with calculating. I have two fields in play… one is the amount of the account and the other is a “yes/no” paid field. I want a text label to display the sum of the amount of all accounts which have a “no” in the paid field. Similar to the SUMIF function in excel.

Thanks,
Travis

[mebeingken]

Hey Travis!

Here’s how you would do that (I’ve included formatting as Currency, but you can format however you want):

Best of luck on your budget app!

–Ken

---

Looking to accelerate your app development?

Development of Advanced Apps at https://uniqueideas.com or schedule a free intro session

Ken Truesdale
LinkedIn

[travismittel2]

Thank you so much!