Hello,

I need to set up a simple two-variable sensitivity analysis table. I have researched data tables and attempted to set one up but I get an error.

I believe my problem is the structure of the output formula. When I change the two variables, they affect 4 different outputs, which I then SUM. That SUM is what i'd like to build my sensitivity analysis with.

I can reference a single cell and have it change when I change my two input variables but I still get an error when I use a simple reference as the formula in the data table.

Here is an example of the data I am trying to put into a data table:

In A1, we have a reference to where the output is and B1:D1 is a # of units and A2:A4 is a growth rate. The other cells are the output based on the sum from another page.

='DifferentWorksheet'!$T$36 0 50 100
0% 24,000 28,000 31,000
5% 26,000 30,000 32,000
10% 28,000 32,000 34,000


Also, I have researched different add-ins that apparently do sensitivity analysis but my PC is controlled by IT and I cannot install third-part add-ins.

Does anyone have any insight as to why the data table won't work? Am I correct in my thinking why it wont? Or does anyone have any other suggestions to easily build a sensitivity table?

Any help would be greatly appreciated.