Sum if with two criterias

Please pick a subcategory to help organize the information. Thanks!

Also, the more context you provide with your questions (screenshots, link to an open app, etc.), the more likely you’ll get good help quickly :slight_smile:

I have 3 fields in a table: COLABORADOR (wich has names Braima, Secuna), STATUS (filled with “yes” or “no”), and field VALUES, só I want sum Values that match chriteria: Colaborador=“Braima”, Status=“yes”.
I tried but no success, I need help please.

Hi there, @sbaiocassama… it would be good if you could share some screenshots of your setup, but you should be able to do a search on the relevant data type, add constraints to the search where Colaborador = Braima and Status = "yes", and then sum (use the :sum operator) each item’s value. So, it would probably look something like this.

Hope this helps.

Best…
Mike

1 Like

Thank you a lot. It works perfectly

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.