Oct 11 2021 01:58 PM
Hello, I have a dataset that is essentially this. What I need to do is to count the total number of employees by Country (not City). I'm having a hard time finding the correct formula for this. It is not shown in this example dataset, but there are some cases that the city has the same name but is a different country.
Basically, I want to identify the unique values from column B (which will have a correspondent value in column C which might or might not be repeated), to then SUM the values from column C and my range of values is the filtered values for each country from column A.
I was thinking two nested UNIQUE formulas or maybe FILTER, but I just can't get the correct syntax, Someone can think of a solution? It will be much appreciated!
Oct 11 2021 02:10 PM
I'm confused.
You write "count the total number of employees by Country (not City)". If that is correct, it does not matter whether there are cities with the same name in different countries.
Oct 11 2021 02:18 PM
Oct 11 2021 02:32 PM
SolutionSee the attached version. I used a helper column, and I added two solutions: one formula-based and the other a pivot table.
Oct 11 2021 03:15 PM
Oct 11 2021 04:15 PM
Here is a solution without a helper column.
Oct 11 2021 02:32 PM
SolutionSee the attached version. I used a helper column, and I added two solutions: one formula-based and the other a pivot table.