Calculate previous rows with condition as sumifs function in excel

[lzhang775]

Hi,

Could any one help me with this calculation formula? I need to calculate in column 3, but have no idea how. column 3 formula in excel would be like this:

Thank you for your help!

Lee

[Emil_Kos · Accepted solution]

Hi @lzhang775,

I needed to sort the data by customer ID but I hope this isn't an issue.

If it is please let me know and I will use Record ID to sort it in the previous order.

Output:

Please mark my post as an answer if this was something helpful!

[Emil_Kos]

Hi @lzhang775,

Thank you for marking my post as an answer!

Good Luck with your projects!

[lzhang775]

Hi Black Knight,

This is a very good solution, it works like a charm. Thank you!!

LEE