Finding the sum of fields in Airtable

Finding the sum of fields in Airtable

Finding the sum of a field is one of those scenarios; since formulas apply only to other fields within the same record, you can't create a formula in one record that only references other records in the table. Instead, you can sum an entire field by taking the following steps:

1. In Airtable, navigate to the table that holds the records that you want to sum.  For example’s sake, let’s call this table “Values.”

2. Create a new linked record field that links records in the “Values” table to a new table. Let’s call this new table “Calc" short for “Calculation.”

   1. Note that you could also link this field to an existing table in your base.

3. Next, create linked relationships between the “Values” and “Calc” tables.

   1. Summing all record values - Populate every record in the linked record field with the same record in the “Calc” table. You can do this quickly by using the fill-handle. For example, you could title that record in the “Calc” table “All.”

   2. Summing certain record values - Populate only certain records by only linking those records to a different record in your “Calc” table. You can also potentially link more than one record from the “Calc” table to the linked record field in your “Values” table. This will create multiple calculations in the “Calc” table based on which record you link from your “Values” table.

4. In the linked “Calc” table, create a Rollup field that sums the number field with the SUM(values) function.

   1. You can also use other rollup field functions to calculate averages or more complex rollup field formulas.

Note

If you only need to quickly see the sum of an entire field - and not use that sum in another formula - you can quickly do so by toggling on the SUM function in the summary bar.