patreilly441
New Member
- Joined
- Mar 16, 2017
- Messages
- 2
Hello, Any help will be greatly appreciated . Using my example below, I want a formula to look for the Territory ID in Table 2 and find it it Table 1 and when it is found sum up only Value1, Value2 and Value5 (Columns B, C, F) for that row.
In the example -- the answer is 9. I can't figure out the formula that I would use in Table 2 . I have tried SumIf, Vlookup, combinations and i am just not getting it done.
Table 1
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
Table 2
<tbody>
</tbody>
Thank you very much. Pat
In the example -- the answer is 9. I can't figure out the formula that I would use in Table 2 . I have tried SumIf, Vlookup, combinations and i am just not getting it done.
Table 1
Territory ID | Value1 | Value2 | Value3 | Value4 | Value5 |
11 | 1 | 1 | 1 | 1 | 1 |
12 | 1 | 1 | 1 | 1 | 1 |
13 | 1 | 1 | 1 | 1 | 1 |
14 | 1 | 1 | 1 | 1 | 1 |
15 | 1 | 1 | 1 | 1 | 1 |
11 | 1 | 1 | 1 | 1 | 1 |
12 | 1 | 1 | 1 | 1 | 1 |
13 | 1 | 1 | 1 | 1 | 1 |
14 | 1 | 1 | 1 | 1 | 1 |
15 | 1 | 1 | 1 | 1 | 1 |
11 | 1 | 1 | 1 | 1 | 1 |
12 | 1 | 1 | 1 | 1 | 1 |
13 | 1 | 1 | 1 | 1 | 1 |
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
Table 2
Territory ID | Sum |
11 | formula? |
12 | |
13 |
<tbody>
</tbody>
Thank you very much. Pat