Skip to main content
Best answer

How to calculate the total sum of a Zapier table column


Hello all. The thing I want to do is that I want to SUM up all the numbers in this specific column “Monthly Profit” on a Zapier table.

 

 

I can’t just put them all as line items as this Zap will run everytime a new form (new month) gets submitted. So I can’t just do =SUM(row1, row2, row3) because a 4 will get added next month. I’ve also tried spreadsheet style of =SUM(“Monthly Profit”) ala Excel but it doesn’t work.

Can anybody help me in figuring this out? Thank you. 

Best answer by SamB

Just circling back in here to share that we’ve added Summary formulas to Zapier Tables which can be used to calculate the total sum of a table column! 🎉

Check out the Add a summary formula to a field in Zapier Tables guide to learn more.

Also, we’ve recently added Formula fields which you can learn more about here:

Happy Zapping! 😁⚡

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @creativelife 

Try these Zap steps:

  1. Trigger: [APP] - [EVENT]
    1. UP TO YOU
  2. Action: Zapier Tables - Find Records
    1. Need to add a column with a common value for all the records to use as the lookup
  3. Action: Formatter > Numbers > Perform Math Operation
    1. Type: Add
      1. Used to SUM the values
  4. Action: [APP] - [EVENT]
    1. UP TO YOU

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7274 replies
  • October 9, 2024

Hey @creativelife 👋

How did you get on with Troy’s suggestion here? Did that approach help to get the sum of all the values in that Monthly Profit column?

Let us know if you’re still stuck on this at all, keen to ensure you’re all set! 🙂


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7274 replies
  • Answer
  • February 7, 2025

Just circling back in here to share that we’ve added Summary formulas to Zapier Tables which can be used to calculate the total sum of a table column! 🎉

Check out the Add a summary formula to a field in Zapier Tables guide to learn more.

Also, we’ve recently added Formula fields which you can learn more about here:

Happy Zapping! 😁⚡