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).
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel won't recognize data
- Thread starter mietex
- Start date
Excel Facts
How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Similar threads
- Solved
