Add the values of a cell when another cell matches...

Hi ​@Stevet 

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

• GSheets - Lookup Rows

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

• Formatter > Utilities > Line Items to Text
  • Delimit with a comma
• Formatter > Numbers > Spreadsheet Style Formula
  • SUM()
  • Help: https://help.zapier.com/hc/en-us/articles/8496181204877-Available-spreadsheet-style-formulas

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! 🙂