Finding the sum of fields in Airtable
  • 14 Dec 2023
  • 1 Minute to read
  • Dark
    Light
  • PDF

Finding the sum of fields in Airtable

  • Dark
    Light
  • PDF

Article summary

This article covers how to find the sum of fields in Airtable to streamline your team's and organization's work.

Introduction

Plan availability

All plan types 

Platform(s)

Web/Browser, Mac app, and Windows app 

Related reading

Finding the sum of fields in Airtable

Finding the sum

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. 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.

Screen Recording 2020-01-27 at 04.31 PM

  1. In the linked table, create a Rollup field that sums the number field with the SUM(values) function.

Screen Recording 2020-01-27 at 04.31 PM_1

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:

  1. Create a new record in your linked table (Table 2 in the above example).

  2. Link that single record to each of the records you'd like to sum in Table 1.

  3. 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.


Was this article helpful?