Group by IDs and calculate

[OCM]

Greetings,

Using Excel 365 and given the following in the attached sample:

Amount due = Settlement #1 – Collection amount (if Settlement #1 is not blank)
Amount due = Settlement #2 – Collection amount (if Settlement #1 is blank)
If Amount due = 0, then display “no amount due”

I would like to create a new column to calculate the itemized collection payments/amt. and display the amount due per CustID at the bottom. Please see the expected result in the attached sample.



TIA

Regards,

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.