Search code examples
excelexcel-formulaworksheet-functioncountif

Count frequencies if values of other column are equal to specific text

City            Job
London          Webdesigner
London          Webdesigner
Tokio           Lawyer
Tokio           Teacher
Buenos Aires    Manager
London          Athlet
Rome            Doctor
London          Webdesigner

I'm looking for a way to count the frequency of Webdesigner if "City" is equal to London (in same row). The result of the formula should be 3.

Solution

  • Assuming City is in A1 please try: 

    =COUNTIFS(A:A,"London",B:B,"Webdesigner")