title: Getting Summation from a Table, with matching values from another Table in Excel
body: <p>I have 2 tables created in Excel, which are identical in structure and the column and row names. </p>
  
  <p>The only difference is that the first table has data (for the effort in work days) in it while the second is a reference table stating which milestone each cell belongs to. A sample of these tables is:</p>
  
  <p>TBL1:</p>
  
  <pre><code>|    | App1 | App2 | App3 |
  | T1 |  32  |  12  |  48  |
  | T2 |  40  |  16  |  30  |
  | T3 |  56  |  18  |  36  |
  </code></pre>
  
  <p>TBL2:</p>
  
  <pre><code>|    | App1 | App2 | App3 |
  | T1 |  1   |  2   |  3   |
  | T2 |  2   |  1   |  2   |
  | T3 |  1   |  1   |  1   |
  </code></pre>
  
  <p>I want to collate these values so that I get SUM of 1, 2 and 3</p>
  
  <pre><code>|    | Days Summation   |
  | 1  |  =32+56+16+18+36 |
  | 2  |  =40+12+30       |
  | 3  |  =48             |
  </code></pre>
  
  <p>So basically, want to find:</p>
  
  <pre><code>IF(COL_VAL_IN_TBL2=1) THEN SUM ALL VALUES IN TBL1 CORRESPONDING TO THE ROW-COL IN RESPECTIVE 
  </code></pre>
  
  <p>Is it possible to get a formula which I can use to do this without using something like a Pivot Table?</p>