Hi All,
I have two tables in the same layout where i am trying to multiply them against each other (think 'Table1'C1 multiplied by 'Table2'C1, 'Table1'D1 multiplied by 'Table2'D1, etc.)
Here are two sample data sets that i am trying to calculate with a 'Table1' multiplied by 'Table2'
Table1:
| Y1 | Y2 | Y3 | Y4 |
| 543 | 543 | 543 | 543 |
| | 123 | 123 | 123 |
| | | 765 | 765 |
| | | | 987 |
Table2:
| Y1 | Y2 | Y3 | Y4 |
| .2 | .1 | .5 | .3 |
| | .2 | .1 | .5 |
| | | .2 | .1 |
| | | | .2 |