Excel - SUM Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.