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

    How to remove these Duplicated Values in Calculation


      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)






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