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

Christopher Broom

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?

Paul Newcome

You would need to include a helper column. In that column you would use a SUMIFS to output the total $ amount on each row based on the transaction identifier. You can then use a COUNT/DISTINCT/COLLECT formula to count the distinct entries in the transaction column based on the helper column being greater than zero.