1 Reply Latest reply on Apr 28, 2015 6:27 AM by Geoff Koch

    How to remove these Duplicated Values in Calculation

    phuviet.pham

      Hi every one,

       

      I have Workbook like the attachment.

       

      All the same Category will always have the same Category Sale Status. what i want is to count the number of Category having the same Status without dupplication. Here is the Result i want to have:

       

      Number of Categories  with Status "green": 2 (they are: Category Ax and Ag)

      Number of Categories with Status "red": 1 (Its Category Ay)

      Number of Categories with Status "orange":1 (Ist Category Az)

       

       

       

      Data1.png

       

      Can you please help me?. How to do that? Thanks