Google sheets, update value BUT sum numbers

Status: Closed · Asked by olimckenna on · 0 views

olimckenna — Question ·

Hello, I am pushing Woocommerce data to Google sheets, the set-up is a little complicated and probably not needed for context, long story short:

With every new event/sale of a specific product, I want to update the cell value but not just add the value of the recent order but to sum them

E.g. Order 1 value is 40 EUR
Order 2 value is 40 EUR

the cell value would be for product ABC 80 EUR

Essentially I want to see how much in monetary value was one product sold for

Is this possible?

Thanks

olimckenna — Reply ·

Solved it with math operations and fetching old + new data

Back to all forum threads · Log in to reply