- 08 Jul 2024
- 1 Minute to read
- Print
- DarkLight
- PDF
Finding the sum of fields in Airtable
- Updated on 08 Jul 2024
- 1 Minute to read
- Print
- DarkLight
- PDF
All plan types | |
Platform(s) | Web/Browser, Mac app, and Windows app |
Related reading |
This article covers how to find the sum of fields in Airtable to streamline your team's and organization's work.
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:
Create a new linked record field, and populate every record in the field with the same value. You can do this quickly by using the fill-handle. You can either link this field to an existing table, or create a new table directly from the field settings.
In the linked table, create a Rollup field that sums the number field with the SUM(values) function.
You can use this setup to sum the values of any range of field by adding the same linked record (from Table 2) to each record in Table 1.
You can use the above principle to sum as many fields as you need across your tables. The process will be the same:
Create a new record in your linked table (Table 2 in the above example).
Link that single record to each of the records you'd like to sum in Table 1.
Watch the rollup field referencing Table 2 SUM the values.
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.