Count the number of transactions which are cumulatively equal to or greater than $0?

Options

I have a column of unique transaction IDs. These transactions sometimes are reprocessed. I only want to count the transactions which netted positively. For example, transaction A is processed and shows up but then it is returned whereby it shows up again as a negative. I do not want to count that as a transaction. However, if Transaction A was processed, returned, and then reprocessed I want to count that as one transaction. I want to ignore any transactions which were just returns.

Example: I have manually added up the number of transactions.

How do I get this number of transactions correctly totalled by SmartSheet?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!