hi;
First thanks for your time in checking on this thread to help.
id like to work out column k that deals with (total payments of each of the customer that i am getting via sumif formula and it keeps on updating periodically). i have manually done column k so i am wondering is there a way to nicely get this done using a perfect formula.
This is actually total payments - individual invoices and also, if yes can this be termed as paid or not paid considering the paid amount is greater than the billed amount.
Reference sheet attached that contains data. please feel free to ask questions and big thanks in advance for your help!...