How do I automatically add up all values in a column?


#1

Let’s say I have the price of several items in column A, and I plan to add more items periodically. How do I create a field that automatically tallies the total of column A as I add each item?

Thanks for your help!


#2

If you add a Currency Field within your table with your price within it.

Airtable will show a SUM at the bottom of the page calculating the total amount of all records displayed.

If a filter where added it would show total amount of filtered records,

Grouped groups would show total amount of each group and if filtered would show amount of group filtered.

Hope this helps.


#3

Is it possible to then take the “total amount” and use that in other areas? For example in a Airtable function, or in a Zapier zap? I really like that Airtable rolls that date up, but I can’t seem to figure out how to access that data.