What is the easiest way to sum all "GL No" from 1000-1099 in range A2:D9 relating to cash in Table 1 and place total into cell A2 in Table 2? ...2200-2299 in "Inventory" on Table 2 and 5000-5099 in "Payable" on Table 2 . I have created a helper column but there must be a better way.....any help?
Table 1
<tbody>
</tbody>
Table 2
<tbody>
</tbody>
Table 1
GL No | GL Description | Debit | Credit |
1001 | Petty Cash - EUR | 1000 | |
1002 | Petty Cash USD | 200 | |
1003 | Petty Cash - MXN | 2000 | |
2200 | Inventory Dry Goods | 46 | |
2201 | Inventory MF1 | 200 | |
2208 | Inventory MF2 | 300 | |
5010 | Payable USD | 72 | |
5011 | Payable EUR | 100 | |
5012 | Payable CAD | 70 |
<tbody>
</tbody>
Table 2
Cash | 3200 | ||
Inventory | 546 | ||
Payables | 242 |
<tbody>
</tbody>