selecting and summarising random repeats

Hi wizards

I have a sales ledger which shows invoice no, customer name, invoice value, and amount paid, I wish to produce a summary that shows a one line entry for customers that have unpaid. The problem I have is if a customer has more than one invoice unpaid, I get an entry for each invoice.

I also want to count the number of customers, on the sales ledger, which sounds easy enough but again I can't get round duplicates

Thanks

Heres a sample file

There's no need to enable the macros in tha attached sample, they are for the original worksheet, the summary page has a partial solution that works for each unpaid invoice by using a macro. but I'd prefer it to be done by formula to show a one line entry for each unpaid customer if that's possible.

Thanks in advance

Does anybody know how to do this?

let's try a Bump!

Thanks very much Stanleydgromjr

That works really well for total number of customers and the number of unpaid customers will then just be a simple Count function if I can get the summary part sorted. What I'm trying to do is get a subtotal for each individual customer who has unpaid invoices. It's easy enough if I type the customer name in, however I'd like it to be self generating, is that too tricky?

bumptity bump

I've uploaded another sample, what I am trying to achieve is a list of debtors in the A column on the Summary page consisting of a single entry for each customer that has unpaid invoices. Some customers may have more than one invoice so the basic problem I have is to reduce the list so that a customer only appears once.

I seem to be hitting brickwalls and my brain is now beginning to hurt. I've attached another sample worksheet which shows exactly what I am miserably failing to achieve. I'm sure there's a simple enough solution please someone look at it before I scratch my eyes out!!!

Thanks again in advance