Not as self-explanatory as you'd think.

Please select one customer and determine what the answer should be in that column, then tell us how you got that answer and point to the data. Then we can think about turning that into a formula.