Sep 08 2021 04:27 AM
Hi,
In screenshot attached; a customer has ordered products over the multiple POs - in columns E & F I have removed duplicates so that in column G I can calculate the total per product per PO. What is the formula for column G please?
E.g Product "CPNY-22-356" has been ordered over two POs. I want it to calculate the total for PO 440435 = 400, and for PO 440453 = 210