Count Unique Values Matching Criteria from Other Column

I seek to count how many unique values from column A exist that match a value from column P-- so that I can tell how many unique inventory ID numbers exist that match inventory codes for different criteria.

I have tried
=countifs('July Orders'!$A:$A,(Match('July Orders'$A:$A,'July Orders'$A:$A,0)),'July Orders'!$P:$P,"01*")

but that doesn't work.

Any advice would be greatly appreciated!

And--not to complicate things, but I also would have call for a conditional count for unique values in $A:$A if $P:$P="29*" AND $C:$C<>{"*Bread*" ,"*Pizza*"}

can you make an example spreadsheet with what the data looks like as well as the expected output?

I think it is going to be something similar to

=COUNTIFS('July Orders'!$A:$A,P#) where P# is the cell in column P that you are trying to match to.

Book1.xlsx

I tried the formula shown above and it returned a value of 0--whereas the correct formula should return a value of 2 (DD70059 and DD70231 are unique item codes listed as being "01-Non-Foods" in column P)

The source data actually consists of x>=1,000 rows of data and ~30 categories--and may be sorted or filtered at any time. Though I'm not entirely clear the role that the ROW function plays in this formula, I believe it would be thwarted if the first instance of P="01*" showed up in row 576--or if you don't necessarily know what row it shows up in (because that may change if the data is re-sorted).

The fact that data may be sorted doesn't necessarily matter for using IF($P:$P=A10 as a static cell can be created to reflect the value sought.

And--also--how/ would this work when the determining factor is if A?="29*" and C?={"*Bread*","*Pizza*"}?

Thanks,
Jsharrard

Hi!
Need help please!
I want to create countifs formula to count how many unique PO's was issued for each buyer for 2012 with status Completed.

Countifs works fine but my problem is nesting a formula to determine only unique values.

Here below are sample table.

BUYER PO DATE STATUS
GOPA 692735 11/05/2012 Completed
GOPA 692090 13/10/2012 Completed
GOPA 706391 18/04/2012 Partially completed
CRIZ 697459 19/04/2012 Partially completed
CRIZ 697459 26/04/2012 Completed
CRIZ 697459 04/05/2012 Completed
CRIZ 697459 10/12/2012 Completed
CRIZ 697459 23/01/2013 Completed
CRIZ 697459 15/11/2012 Completed
CRIZ 697459 16/10/2012 Not compl.
CRIZ 697459 26/06/2013 Completed
CRIZ 697459 06/12/2012 Completed
CRIZ 696494 30/04/2013 Completed
CRIZ 742422 04/12/2012 Completed
GOPA 704663 24/04/2012 Completed
GOPA 701281 24/04/2012 Completed
GOPA 699192 07/09/2012 Completed
CRIZ 700892 12/06/2012 Completed
CRIZ 695038 26/04/2012 Completed
CRIZ 695020 24/05/2012 Completed
CRIZ 698305 04/11/2013 Completed
CRIZ 698318 04/11/2013 Partially completed
GOPA 698281 18/12/2012 Partially completed
GOPA 730951 05/10/2012 Completed
CRIZ 695524 09/10/2012 Partially completed

Thanks! I had posted a new thread...