Can someone please help. Trying to build a function in a function. I want to search row A for the Charge number, when they match the cell should sum up the $amount from the corresponding cell in the other row. Looking for a formula that needs to be flexible for new columns. Is there an easier way to do this? I have it done manually for each cell right now.....and I have many cells.... Please can someone help. Thanks.


Example:

___A____ ___B___ _C_ _D_ _E_ _F_ _ G_ _H_ _I_

1 Charge Num: 123-45 5000 5530 5532 5532 5002 5532 5002

2 In CAO: $0 $7 $1 $2 $-1






3 (dollar amounts are in thousands)
4 05000 - GW Project (labor) 0
5 05002 - GW Project (subc) - 1
6 05530 - Prop Divest (labor) 7
7 05532 - Prop Divest (subc) 3
Total 9