I am trying to calculate collections (payment/charges) but the payments and charges are not on the same row. To circumvent that problem, I tried to create a formula essentially stating "if unique id, Item number and date of purchase match, divide the sum of payments by the sum of charges”, but formula didn’t work.

What is the best way to calculate this?