Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi All,

 

I have a spreadsheet of currency values, each row has a value and a transaction ID.

Where one or more lines has a matching ID, I need to add the currency values together.

 

For example:

1111     $10

1111     $2

1111    $5

1112     $100

1112     $25

 

From that data set, I would like to get back:

1111     $17

1112     $125

 

Is this possible with Zapier?

Hi ​@Stevet 

Which spreadsheet app are you trying to use? (name)

  • GSheets - Lookup Rows

 

Formatter help: https://zapier.com/apps/formatter/integrations#help

 

Hi Troy,

The data is originally from an XLS file that has been parsed by docparser (extracting the rows I need) and resulting in a table of information in Zapier.

I have been playing with the sum formula, but I can’t see how to combine this with an IF.

(ie: if the ID for this row, match the ID with the next row, then sum the two cells.)

 

​@Stevet 

If you are trying to sum data across different matching IDs, then you will need to use a custom Code step.

Code: https://zapier.com/apps/code/integrations#help

 

If you are looking to hire help, there is a directory of Certified Zapier Experts: https://zapier.com/experts

Thanks, I was hoping to do this without cutting code, but it may be a step too far.

Hi ​@Stevet 👋

Hope you don't mind me jumping in here. Just wanted to share that if you’re not super comfortable coding you could always try using our AI-powered feature for Code steps that can write the necessary code for you: Generate a Code step using AI (Beta). 

But if you’d prefer some more hands-on help, connecting with a Zapier Expert as Troy mentioned, would be a great next step. 

Let us know how it goes or if you have more questions! 🙂

Terms & Conditions