Forum Discussion
Bonyo
Jun 15, 2020Copper Contributor
Formula for COUNTIF with more than one VLOOKUP condition / criteria
Hi, I'm trying to generate a formula that will count the number of experts with specific expertise in each country and generate the result in Column K (red text). Table 1 shows experts already...
SergeiBaklan
Jun 16, 2020Diamond Contributor
That could be
=COUNTIFS(Experts_Table[Country],[@Country],Experts_Table[Expertise],[@[Expertise Requested For]])