About this app
This app allows you to add Countifs, Sumif, and Averageif formulas to Airtable that alternative spreadsheet tools like Google Sheets and Excel offer. While there are a few workarounds on Airtable, they can take hours to set up and require you to use extra fields to link records.
Our solution
Our step-by-step app helps you run the following formulas on your Airtable project in minutes:
- Countif or Countifs
- Sumif or Sumifs
- Averageif or Averageifs
The criteria range can be checked in other tables without needing to link records. Plus you can set your criteria as equal to, not equal to, greater than, or less than an Airtable field or custom value (eg. > 30). The calculations of the formula get added to each record on your table, so you can reference the data on other fields.