Sum up values from different tables

[Guilherme_Pires]

Hello, I’m new to the airtable and any help will be welcome.

I have multi tables with payments made in cash and credit card.
I used the multi-choice field type to differentiate the payments.
How can I add up all the amounts paid in cash from all the tables I have?

Obrigado!

[Elias_Gomez_Sai]

What are your tables? Why you don’t have all the payments in the same table?

[Guilherme_Pires]

Elias,
I have the tables separated by areas of expense (building material, staff, food…etc) some expenses were paid in cash and others in credit card. I would like to sum the amounts paid in cash from all tables in a “Summary” table.

Thanks for your help!

[Elias_Gomez_Sai]

I’d recommend you to merge those tables into an unique Expenses table, with a single select field for Area, as you’ve made with Payment Method. Then you will know very easy the amount by Method, Area, or any other field, by using the Grouping feature.

Airtable - Support

Guide to grouped records

Airtable's grouped records feature allows you to show your records grouped together based on one (or more) fields of your choosing.  You can also use grouped records to generate reports—see this s...