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...
peteryac60
Jun 16, 2020Iron Contributor
Hi
I think you were nearly there - but use COUNTIFS instead of COUNTIF - see attached.
Hope this is what you need!
Peter