LinkBack URL
About LinkBacks
I want to calculate from cells B2 to B16 which contains the Ruppe symbol in every cells. The sum formula doesn't works of this its shows the value as 0. Pls help.
I want to calculate from cells B2 to B16 which contains the Ruppe symbol in every cells. The sum formula doesn't works of this its shows the value as 0. Pls help.
Last edited by dhamuvn; 02-06-2012 at 01:49 AM.
Hi ,
a possible solution
Regards
=SUM(INDEX(SUBSTITUTE(B2:B16,"`","")+0,0))
नमस्ते
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Thanks for your valuable solution. While using this in some other symbol such ▲,▼ unable to get the result. It shows a value error. I have attached the sample sheet for your reference..
Hi
May be another
convert into values in column C then use sum function
RegardsC1: =VALUE(RIGHT(B2,LEN(B2)-1))
Mark the thread as solved if you are satisfied with the answer.
In your first post under the thread tools.
Mahju
Hi,
See the attached for another answer.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi
and if you want for both Left & right symble mix the two
=IF(ISNUMBER(VALUE(LEFT(B2,1))),VALUE(LEFT(B2,LEN(B2)-1)),VALUE(RIGHT(B2,LEN(B2)-1))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks