Question description:
This user has given permission to use the problem statement for this
blog.
Can't add (SUM) in imported numbers from bank account
Solved by F. C. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
20/08/2018 - 12:26
HI
Excelchat Expert
20/08/2018 - 12:26
Welcome to Got it Pro
Excelchat Expert
20/08/2018 - 12:26
Please tell more about the requirement so that i can help better
User
20/08/2018 - 12:27
On an imported spread sheet from my bank account, the SUM function won't work
Excelchat Expert
20/08/2018 - 12:27
Can you share the data on the spreadsheet so that i can have a look
Excelchat Expert
20/08/2018 - 12:27
Please show me where the sum function is not working
Excelchat Expert
20/08/2018 - 12:31
Are you there?
Excelchat Expert
20/08/2018 - 12:31
Please share the data so that i can help you out
Excelchat Expert
20/08/2018 - 12:32
Where is the sum required?
User
20/08/2018 - 12:32
each column
User
20/08/2018 - 12:34
Are you still there?
Excelchat Expert
20/08/2018 - 12:34
Yes
User
20/08/2018 - 12:34
ok
Excelchat Expert
20/08/2018 - 12:34
The numbers are not in proper format
Excelchat Expert
20/08/2018 - 12:35
they are not copied in number format
User
20/08/2018 - 12:35
How do I change that?
User
20/08/2018 - 12:35
Because that's how they come when I import them
Excelchat Expert
20/08/2018 - 12:36
They are plain text and symbol before them is making the difference
User
20/08/2018 - 12:37
OK, I'll try highlighting all the numbers and making them currency
User
20/08/2018 - 12:38
do you think that will work?
Excelchat Expert
20/08/2018 - 12:38
Get rid of symbols and then convert to numbers
User
20/08/2018 - 12:39
How can I get rid of the symbols?
Excelchat Expert
20/08/2018 - 12:39
while importing try to get rid
User
20/08/2018 - 12:39
without having to delete each one
User
20/08/2018 - 12:40
Too late ---- I've already got hours into this spreadsheet since importing
Excelchat Expert
20/08/2018 - 12:41
See column O
Excelchat Expert
20/08/2018 - 12:41
Do you see?
User
20/08/2018 - 12:42
yes
Excelchat Expert
20/08/2018 - 12:43
See column P
Excelchat Expert
20/08/2018 - 12:43
and then see cell P302
Excelchat Expert
20/08/2018 - 12:43
Let me know if this helps
Excelchat Expert
20/08/2018 - 12:43
this is how we can do
User
20/08/2018 - 12:43
So... what did you do?
Excelchat Expert
20/08/2018 - 12:44
In column O i extracted the number right of euro sign
Excelchat Expert
20/08/2018 - 12:44
then converted them to number using value function
Excelchat Expert
20/08/2018 - 12:44
and then sum in P302
Excelchat Expert
20/08/2018 - 12:44
Do you understand?
User
20/08/2018 - 12:45
How did you extract the number?
Excelchat Expert
20/08/2018 - 12:45
using this
Excelchat Expert
20/08/2018 - 12:45
=MID(A2,2,LEN(A2)-1)
User
20/08/2018 - 12:45
each column?
User
20/08/2018 - 12:46
Let me try
Excelchat Expert
20/08/2018 - 12:46
Sure
Excelchat Expert
20/08/2018 - 12:49
Please do give good rating and reviews..it really helps
Excelchat Expert
20/08/2018 - 12:56
Are you there?
Excelchat Expert
20/08/2018 - 12:56
Please let me know if you need any more help
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.