Google sheets, update value BUT sum numbers

[olimckenna]

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]

Solved it with math operations and fetching old + new data