I am working on a Google spreadsheet as below:
Walkin date | Name | Phone | Status | Remarks
01/06/15 | Client1 | 1001 | Open | Will join soon
03/06/15 | Client2 | 2002 | Sales | Enrolled
04/06/15 | Client3 | 3003 | Sales | Enrolled
07/06/15 | Client2 | 2002 | Sales | Enrolled
Everything else working fine, just could not figure out this very formula which should calculate the number of Unique Sales, that is in this case: 2, and NOT 3. In other words, the condition I am not able to create is: Count number of unique values (Column 3 [Phone] ) where Status (Column 4) is “Sales”.