TABLE 1 LOOKup by column B (Countries) in TABLE 2 and bring the sum of the values in 2nd column (Table 2)

Question

TABLE 1 LOOKup by column B (Countries) in TABLE 2 and bring the sum of the values in 2nd column (Table 2)

Anonymous

Hello.

I have a mental block.

Can you see the table?

Both tables are small. Copying a formula into column C and adjust them by # of countries per region is not an issue.

My problem is not remembering the formula for C3 to lookup in the WHOLE of Table 2 and find countries and then sum the values in column F.

Any help here?

Thank you!

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

1 additional answer

Answer 1

HansV 462.6K MVP Volunteer Moderator

If the countries are the same row for row in each table, you could simply use =SUM(F2:F9), =SUM(F10:F12) etc.

If they are not in the same order, you could use

=SUMPRODUCT($F$3:$F$200*ISNUMBER(MATCH($E$3:$E$200,B3:B9,0)))

in C3,

=SUMPRODUCT($F$3:$F$20*ISNUMBER(MATCH($E$3:$E$20,B10:B12,0)))

in C10 etc.

0 comments

Answer 2

Anonymous

Hans, perfect! It worked!! Thanks a million for the multiple options. Very thorough as always.

0 comments

Share via

TABLE 1 LOOKup by column B (Countries) in TABLE 2 and bring the sum of the values in 2nd column (Table 2)

1 additional answer