Non-table look ups

R

Rich Mogy

I have the following data in cells a1 to k10
Currency Code1 Amount1 Code2 Amount2 Code3 Amount3 Code4 Amount4 Code5
Amount5
CNY COST 17.37 DIREXP 192.17 PRC_TAX 10.99
EUR COST 2402.67 DIREIMB 1860.76 DIREXP 4241.73 FEES 486797.77 VATRECC
19001.91
GBP COST 9026.2 DIREIMB 355724.51 DIREXP 35340.13 FEES 3587988.52 PAY 0
GBP PAYUK 0 RETC 0 RETF 16900.8 VATRECC 593425.23 WOFF 0
USD ADJC 0 ADJF 0 ARRSV 0 CMARKUP 0 COST -1012614.29
USD DIREIMB 1649750.22 DIREXP 6708856.5 FEES 116078925 FIXPROB 0
FMARKUP -939.42
USD INDIR 75551.69 PAY 249567.58 PAYDO 0 PAYUK 0 PRC_TAX 2994.55
USD RENT125 0 RETC 1834072.56 RETF 2665360.84 UNIWOC 0 UNIWOF 0
USD VATRECC 2108.63 WIPRSV 0 WOFF 0.01 WT 0

I would like to do either one of two things:
1) Write a formula that would sum COST regardless of currency (a hash
total, I know) or sum COST and DIREIMB for a given currency.
or
2) Create a list with all the information in 3 columns - currency, code1,
amount1 so I could use dsum.

Any help would be appreciated. Sorry I couldn't use a mono-space font.

Richard Mogy
 
Top