Unique Counts in Pivot Tables

[lcmast]

How do I use the count function to get a count of unique occurrences in a table of data? For example, I have sales of products by city, and I want to know how many unique products show up. At the same time I am pivoting for other fields (sum of total sales, etc.).

 

[gehusi]

{=sum(1/count(A1:A10,A1:A10))}

Enter via CTRL+SHIFT+ENTER. Change the A1:A10 range to fit your needs.

 

[lcmast]

Can you explain in English what this count function does? I'm trying to use it.

 

[lcmast]

How does this differ from =(1/countif(A:A,A2) for a column and then summing the result in a pivot table?

 

[gehusi]

Full explanation http://www.get-digital-help.com/2009/06/09/count-unique-values-in-a-column-in-excel/ . You'll need to scroll down a bit.