Good day
Hoping someone can help me.
I have a list of invoices from Suppliers that is outstanding. Now i have managed to do a breakdown of how much is owed to each supplier but now i would like the next step to be worked out according to how much is owed to each supplier in a certain month.
I have attached a sample file. First Sheet is outstanding invoices, 2nd sheet is breakdown. I would like to know how i can it to check according to Name, Date and Amount. I have tried SUMPRODUCT, VLOOKUP & TEXT(MMMM) but i don't know how to put into one formula.
Is it possible someone could assist. It would be greatly appreciated
Bookmarks