Summing VLookup Iterations

J

jude

I have a worksheet that calculates a country's GDP based on several
country-specific economic variables. The variables are dynamically
updated when the user selects a country from a drop down listbox. This
result is facilitated using vlookup on another "Base Data" worksheet
that includes the variables for all 192 countries in the world. I am
trying to create a third worksheet ("World GDP") that calculates the
sum of GDPs of all 192 countries to obtain a World GDP total. I am
searching for a non-VBA solution. Any suggestions? I'd really
appreciate the help.

Jude
 
P

Paul

jude said:
I have a worksheet that calculates a country's GDP based on several
country-specific economic variables. The variables are dynamically
updated when the user selects a country from a drop down listbox. This
result is facilitated using vlookup on another "Base Data" worksheet
that includes the variables for all 192 countries in the world. I am
trying to create a third worksheet ("World GDP") that calculates the
sum of GDPs of all 192 countries to obtain a World GDP total. I am
searching for a non-VBA solution. Any suggestions? I'd really
appreciate the help.

Jude
Click to expand...

Put the list of countries down the first column. In the first cell of the
second column put your VLOOKUP formula to get GDP for the first country.
Copy this formula down so you get the GDP for each of the other 191
countries. At the bottom, put a SUM formula to add them up.
 
J

jude

Thanks for trying Paul, but the GDP is determined by several variables
and unfortunately the equation for GDP won't fit into excel. Too many
IF statements.
 
D

Dave Peterson

Use some helper cells and break that long formula into pieces. Then write a
formula that uses those helper cells.

Sometimes for these monster calculations, it's nice to see the intermediate
results just for sanity purposes.
 
Top