Forum

Notifications
Clear all

Vlookup the the total number from one tab to another

4 Posts
3 Users
0 Reactions
81 Views
(@pat)
Posts: 23
Eminent Member
Topic starter
 

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.

 
Posted : 27/06/2022 9:52 am
(@catalinb)
Posts: 1937
Member Admin
 

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.

 
Posted : 27/06/2022 11:26 pm
(@debaser)
Posts: 836
Member Moderator
 

If you do need a formula, you can use SUMIF:

 

=SUMIF(Sheet2!B:B,"Americas",Sheet2!C:C)

for example.

 
Posted : 28/06/2022 3:14 am
(@pat)
Posts: 23
Eminent Member
Topic starter
 

Hi,

Can you site a sample in excel for this.

SUMIF(Sheet2!B:B,"Americas",Sheet2!C:C)

Thanks.

 
Posted : 08/07/2022 1:03 am
Share: