Add a summary formula to a field in Zapier Tables

Summary formulas add a summarization formula to any number field in a Zapier table. You can select from sums, averages, counts, and others.

Available on plans:

Free

Professional

Team

Enterprise

Add a summary formula

To add a summary to a field:

• From the Tables home, click the name of your table.
• Click the down arrow at the bottom of the number field you want to summarize. The summary menu will open.
• Select the summary formula you want to display.
  • Click it again to unselect a summary formula.
• To close the menu, click anywhere outside the menu when you're done.

If you select more than two summary formulas, a plus sign + will appear beside the results in the summary area, along with the number of other formulas you selected. You can display other results by clicking the summary area below the field.

Note

• You can select any number of summary formulas.
• The summary formulas are displayed in the same order they appear in the menu.
• Summary formulas will not appear on a CSV file when you download records.
• You can only add summary formulas to number fields.

Summary formulas and filters

If your table has filters, summary formulas will only consider the visible range of values. The results of summary formulas will change if you update filters.

Summary formulas and views

Summary formulas are not displayed on any views associated with a table. You must add summary formulas for the fields in a view. Summary formulas only take into account the range of values available in that view.

Summary formula types

You can select from the following summary formula options:

Remove a summary formula

To remove a summary formula:

• Click the summary area below the field. A dropdown menu will open.
• Select the formula you want to remove.