# Breaking down a list of supplier invoices

1. ## Breaking down a list of supplier invoices

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

2. ## Re: Breaking down a list of supplier invoices

Cell B4 formula below, copy down and across:
``Please Login or Register  to view this content.``

3. ## Re: Breaking down a list of supplier invoices

Thank you so much. IT gives me an error at the Outstanding, For some reason i have to change the commas for ; Now the only thing is that i have copied and pasted and all totals are now zero

4. ## Re: Breaking down a list of supplier invoices

Breakdown of Suppliers

B4=SUMPRODUCT((Outstanding!\$B\$4:\$B\$52='Breakdown of Suppliers'!\$A4)*(MONTH(Outstanding!\$A\$4:\$A\$52)=MONTH('Breakdown of Suppliers'!B\$3&0))*(Outstanding!\$E\$4:\$E\$52))

Copy across and down

for hide 0 custom formatting [=0]""

5. ## Re: Breaking down a list of supplier invoices

Removed by JT

6. ## Re: Breaking down a list of supplier invoices

Make dates in row 3 as Excel dates e.g 01/01/2021 and format as "mmmm": post #2 formula will work.

7. ## Re: Breaking down a list of supplier invoices

Hi there

Thank you but when i do that all totals are still 0

See attached

9. ## Re: Breaking down a list of supplier invoices

Thank you so much, it worked. Really appreciate your assistance

10. ## Re: Breaking down a list of supplier invoices

Changed dates like you said, I had the formula but had no idea n how to put it all together. Thank you so much for all your help

11. ## Re: Breaking down a list of supplier invoices

Josephteh did the work.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

12. ## Re: Breaking down a list of supplier invoices

Thanks guys, have a great weekend!!!

13. ## Re: Breaking down a list of supplier invoices

Post # 4 works ?

14. ## Re: Breaking down a list of supplier invoices

Originally Posted by josephteh
Cell B4 formula below, copy down and across:
``Please Login or Register  to view this content.``
Sorry, forgot to mention I have converted your months to date. Please see attached file.

Because of your regional setting, you have to change commas to semi-colons.

There are currently 1 users browsing this thread. (0 members and 1 guests)