Excel won't recognize data

[mietex]

I coped a bunch of data from some Explorer pages (bank statements) into Excel and want to use the 'sum' function to total the amounts in a particular column, however Excel only recognizes *some* of the data. I copied it from 2 sets of pages, some reflecting Direct Deposits and some for Bank Checks (but otherwise completely identicle); Excel is only recognizing the data from the Bank Checks pages. The sum function will add the data from Bank Checks, but ignores the Direct Deposit data, and if I try to sum only Direct Deposit data, I get a VALUE# error message. Does anyone know what's going on and how I can get Excel to recognize ALL of the data? (I am not an Excel master, just an average user).

 

[mietex]

P.S. That Macro? That is the best thing that's happened all day