Tag Info

New answers tagged


Use the formula: =COUNTIF(UNIQUE(C:D),"Sales") How it works: Unique(C:D) will remove any rows from those columns that are duplicated, resulting in: Phone | Status -------|------- 1001 | Open 2002 | Sales 3003 | Sales The Countif portion looks inside those resulting duplicate values and counts every instance of "Sales".

Top 50 recent answers are included