Count PO's per Supplier

[jlp]

I know this has been asked a number of ways and I feel I have got myself so convoluted with so much information I cannot make heads or tails out of how I need to write this formula

I have a spreadsheet

Suppl Name	PO
Supplier A	41058
Supplier A	41099
Supplier A	41099
Supplier A	41166
Supplier A	41271
Supplier B	41059
Supplier B	41059
Supplier C	41052
Supplier D	41136
Supplier E	41157
Supplier E	41168
Supplier F	41139

I want the number of unique PO's per Supplier, such as:
Supplier A 4
Supplier B 1

For the life of me I cannot figure out how to do this.

Please help!

 

[jlp]

So, you are no longer looking for unique PO #, then?

If so:
* To get the number of Receipts per Supplier:

=COUNTIF($A$2:$A$16,"Supplier A")

* To get the number of Receipts per Supplier that were on time:

=SUM(FILTER(IF($E$2:$E$16<=$D$2:$D$16,1,0),$A$2:$A$16="Supplier A"))

* To get the number of Receipts per Supplier that were late:

=SUM(FILTER(IF($E$2:$E$16<=$D$2:$D$16,0,1),$A$2:$A$16="Supplier A"))

Sorry for not responding sooner - I was out of the office on Friday.

When I get a chance I will try these suggestions. Thank you very much for responding! : )

 

[jlp]

So, you are no longer looking for unique PO #, then?

If so:
* To get the number of Receipts per Supplier:

=COUNTIF($A$2:$A$16,"Supplier A")

* To get the number of Receipts per Supplier that were on time:

=SUM(FILTER(IF($E$2:$E$16<=$D$2:$D$16,1,0),$A$2:$A$16="Supplier A"))

* To get the number of Receipts per Supplier that were late:

=SUM(FILTER(IF($E$2:$E$16<=$D$2:$D$16,0,1),$A$2:$A$16="Supplier A"))

I understand the formula's that you provided - Thank you.

I noticed though, that I misrepresented what I am looking for.

What I'm trying to get to is:
How many receipts did we receive from our Supplier? - Thanks to you and Fluff I now have that formula

The next two questions are:
How many of those receipts were on time given a 5 day leeway?
How many of those receipts were over 5 days late?

So I understand what the formula's are doing, I just don't know HOW to tell Excel what I want to do:
Count the number of "True's" in column L per Supplier and return that number in Column O
Count the number of "False's" in column L per Supplier and return that number in Column P

Count Lates per Supplier 2.xlsx

Shared with Dropbox

www.dropbox.com