Forum Discussion
Solved
Managing Incoming Payments on Excel
I was wondering if there is a way (or a formula) to manage incoming payments on excel from different people. An example would be person 1 owes 100 dollars and person 2 owes 200 dollars but they each ...
MichaelAyala , I'd suggest to separate credits and payments on two columns, as
Balance here is calculated as
=SUMIFS([Credit],[Name],[@Name],[Date],"<="&[@Date])- SUMIFS([Payment],[Name],[@Name],[Date],"<="&[@Date])
MichaelAyala , I'd suggest to separate credits and payments on two columns, as
Balance here is calculated as
=SUMIFS([Credit],[Name],[@Name],[Date],"<="&[@Date])- SUMIFS([Payment],[Name],[@Name],[Date],"<="&[@Date])
SergeiBaklan Thank you so much! Sometimes what seems like a complicated problem has the simplest solution.
MichaelAyala , you are welcome
