不手工输入数值如何求和.xls

下表格是从银行网页中导出来的,想求和"货方发生额"以乃"余额"但总是不如我愿,请高手指教?注:我将数值重输一遍就可以自动求和了?这是为什么?但这样工作量大增.人民币交易类型凭证种类凭证号对方户名对方账号摘要借方发生额贷方发生额余额转账00转入0281010010.00181.66631.27转账00转入0281010010.00787.151,418.42转账00转入0281010010.00485.781,904.20转账00转入0281010010.00829.812,734.01转账00转入0281010010.00605.683,339.69转账00转入0281010010.001,635.484,975.17转账00转入0281010010.00348.385,323.55转账00转入0281010010.001,548.766,872.31转账00转入0281010010.00201.967,074.27转账00转入0281010010.00201.967,276.23转账00转入0281010010.00180.977,457.20转账00转入0281010010.0018.617,475.81转账00转入0281010010.0051.297,527.10转账00转入0281010010.00121.187,648.28转账00转入0281010010.00355.408,003.68转账00转入0281010010.00143.558,147.23转账00转入0281010010.00228.198,375.42数据-分列-分隔符号选中Tab键，下一步，完成
然后看看是否可以求和现金类交易19410021638,000.000.00375.42转账00转入0281010010.00159.3996559.26转账00转入0281010010.00128.7转账00转入0281010010.00601.72转账00转入0281010010.00224.83转账00转入0281010010.00838.63转账00转入0281010010.00330.96转账00转入0281010010.00107.02转账00转入0281010010.00403.12转账00转入0281010010.001,006.24转账00转入0281010010.00160转账00转入0281010010.00379转账00转入0281010010.00562转账00转入0281010010.00363转账00转入0281010010.00328