How to sum one excel column just the dollar values shown here

Timothy_OM 

Is this data you import from, say, a credit card or bank statement?

If so, although there would be ways to write a formula to get the dollar figures only, it would be a LOT better if you were to rearrange the data to begin with, so that it forms a standard table with columns as shown here.

Date.....Payee/Payor......Amount

So before we affix a bandage to this but not address the underlying wound, is it possible to import or array the data differently. [I am assuming this is just a sample set of data, so doing so with these six items really is not the point]