Hi,
What would be the formula or expression to use if I will need to vlookup the total number of data from one tab to another.
Example would be below:
Country: Region: Employees:
Ohio Americas 20
Delaware Americas 10
New York Americas 5
In the other tab, I will need to get the total of these 3 countries of Americas using vlookup.
The next tab will just show Americas and it should show 35 as the total number of employees. Appreciate your advise. Thanks.
Why not use a pivot table, instead of manually splitting data into tabs with formulas? You can use sliscers to filter data for a specific Region, or you can organize the pivot to show you numbers by region.
See file attached.
If you do need a formula, you can use SUMIF:
=SUMIF(Sheet2!B:B,"Americas",Sheet2!C:C)
for example.
Hi,
Can you site a sample in excel for this.
SUMIF(Sheet2!B:B,"Americas",Sheet2!C:C)
Thanks.