I was wondering if anyone had experience with the count unique function.  Currently, I'm trying to get a count of how many unique PO/Vendor combinations meet a certain condition (Auto-Renew="Yes").   As of now, my formula counts a sum total of all rows that contain the value "Yes" I was hoping to show all unique values that have the value yes.   Here is my current set of conditions and values:

#CostingStandard(CT-Foundation)

Instead of using the Sum function on your Auto Renew Total, try the SumIf function.

If looks like the Unique Values you want to test are already present in your PO and Vendor column, so your formula could be: 
=SumIf(PO and Vendor, PO and Vendor,1)

This translates into something like, "Compare the current row's value for PO and Vendor column value against all the values in the PO and Vendor column and any time a match appears, increment the count by 1. 
For more info: Here's a link to the SumIf function

Hi Eric,

This still returns a sum total, for example, 101001111 - Apptio would return the value 3 since there are 3 rows in the table with this PO and Vendor Combination.  

I need to figure out a way to count only unique PO and Vendor instances where Auto-Renew = YES.  So, in the example above if it were 101001111 - Apptio YES.  It would return the value of 1 despite there being three instances of this PO and Vendor combination in the table.   My thoughts are a formula that would read:   if PO and Vendor Contain "YES" count unique instances.
Original Message:
Sent: 03-09-2021 10:44
From: Eric Self
Subject: Count Unique

Instead of using the Sum function on your Auto Renew Total, try the SumIf function.

If looks like the Unique Values you want to test are already present in your PO and Vendor column, so your formula could be:
=SumIf(PO and Vendor, PO and Vendor,1)

This translates into something like, "Compare the current row's value for PO and Vendor column value against all the values in the PO and Vendor column and any time a match appears, increment the count by 1.
For more info: Here's a link to the SumIf function

Ah, I see. 

If you want to see the count of values, maybe you could try using the UniqueCount formula?  Link to UniqueCount function

If you want to see the actual Unique Values, how about the UniqueValues formula? Link to UniqueValues function

I believe the UniqueCount function will help you get what you're looking for.

Give this a whirl... 😎

Count Unique Step1=If(Auto Renew Contract="Yes",SumIf(PO and Vendor,PO and Vendor,1),"")
Count Unique=1/{Count Unique Step1}

SOLVED.   This works perfectly.   Thanks, Jenny!
Original Message:
Sent: 03-10-2021 11:06
From: Jenny Franklin
Subject: Count Unique

Give this a whirl... 😎

Count Unique Step1=If(Auto Renew Contract="Yes",SumIf(PO and Vendor,PO and Vendor,1),"")
Count Unique=1/{Count Unique Step1}

Original Message:
Sent: 03-10-2021 12:23
From: Aaron Rhoney
Subject: Count Unique

SOLVED.   This works perfectly.   Thanks, Jenny!

Original Message:
Sent: 03-10-2021 11:06
From: Jenny Franklin
Subject: Count Unique

Give this a whirl... 😎

Count Unique Step1=If(Auto Renew Contract="Yes",SumIf(PO and Vendor,PO and Vendor,1),"")
Count Unique=1/{Count Unique Step1}