Forum Discussion
Accounting formula
Thank you in advance. Simply, Have an invoice tracking spreadsheet that is returning incorrect numbers. Let's say column A is what is due, column B is what is paid and I need column C to prov...
Sorry, I have simplified it to much. Actual formula =SUMIF(O2:O385,"<>",H2:H386) goes not help me if a part payment is received.
Column H is wages due. Columns F and G are the same but I calculate them separately (only way I know).
Column O is for payments received.
I will make sure any future questions are detailed.