00:00I'll show you how to best keep track of invoice payment.
00:02Trust me, this will make you look and feel like Excel guru in your office.
00:07If you have worked with SUMIF function and SUMIFs function for criteria-based submission,
00:12this would be another way of using SUM function.
00:16Let's learn.
00:17Consider this data set where you want to calculate what is the total amount that was paid
00:20and what is the total amount that's unpaid.
00:23Normally what you do is say SUM and you add up the monthly dues on column D.
00:27But you can appreciate that this only adds up whatever is due.
00:31But if you want to put a condition, you just multiply that by column E
00:35and the condition for that will be equal paid.
00:38If the condition is false, it returns a zero value
00:40and multiplying it by the monthly due will exclude it from the submission.
00:44And now if you enter the status of paid, you can see it does add up the total in there.
00:49And likewise for unpaid, you just need to remove the paid status into a blank
00:54and then you'll calculate the unpaid values.
00:57You can see it there on screen name textuals
00:58behind the card and the подпис prays.
00:58Please join me in here.
00:58It may be hard to stop keeping it.
00:59Yes.
00:59You can see it.
00:59Thanks a lot of people.
00:59Let me leave.
01:00Thanks a lot.
Comments