I tried to sum below numbers.
IT's in YEN.
It says sum is "0"
" * " is problem in this web site. There is no * between numbers
2*111*000¥
2*111*000¥
2*098*000¥
2*092*000¥
2*098*000¥
2*051*000¥
2*101*000¥
2*104*000¥
2*093*000¥
2*083*000¥
I tried to sum below numbers.
IT's in YEN.
It says sum is "0"
" * " is problem in this web site. There is no * between numbers
2*111*000¥
2*111*000¥
2*098*000¥
2*092*000¥
2*098*000¥
2*051*000¥
2*101*000¥
2*104*000¥
2*093*000¥
2*083*000¥
Last edited by isurum; 04-24-2015 at 12:43 AM.
But what are those * in between?
Cheers!
Deep Dave
mmmm.... it's a problem in this web site.
in excel there is nothing like that.
Please attach your excel..
You have to remove all of the * between the numbers and the ¥. So do the following please.
Assume your data begins in A1 paste this formula into B1 and copy all the way down.
=SUBSTITUTE(SUBSTITUTE(A1,"*",""),"¥","")
Now copy all of the data in Column B and paste Special the values to another column
Select all of the values and Press Ctrl + 1 and format the cells to Currency and select Japanese Yen.
Now select the whole column and Go to Data → Text to Column and press finished.
Now you should be able to Auto Sum.
Assuming your actual data looks like this...
C 12111000¥ 22111000¥ 32098000¥ 42092000¥ 52098000¥ 62051000¥ 72101000¥ 82104000¥ 92093000¥ 102083000¥
Use this for the sum...
=SUMPRODUCT(--LEFT(C1:C10,LEN(C1:C10)-1))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
WoW!!! That is perfect my friend! Do you how to get the average of number series?
And also do you know any easy way to remove space between numbers?
Thanx
isu
The average would be...
=SUMPRODUCT(--LEFT(C1:C10,LEN(C1:C10)-1))/COUNTA(C1:C10)
Not sure what you mean by spaces though?
something like this?
C 132 111 000¥ 142 111 000¥ 152 098 000¥ 162 092 000¥ 172 098 000¥ 182 051 000¥ 192 101 000¥ 202 104 000¥ 212 093 000¥ 222 083 000¥
=SUMPRODUCT(--LEFT(SUBSTITUTE(C13:C22," ",""),LEN(TRIM(SUBSTITUTE(C13:C22," ","")))-1))
Thank you friend!
Numbers are like this...
2 111 000¥
2 111 000¥
2 098 000¥
Is there any easy way to remove space??? Using Format Cells?? etc... Make numbers like this...
2111000¥
2111000¥
2098000¥
Highlight the range
press CTRL H (find/replace)
"Find" (space) - press the space bar
"replace" nothing - leave blank
OK
You could actually do the same thing with the yen sign (copy, then paste into the Find/Replace. You could then just sum the numbers normally
aaaaah!! thank you veryyyyyyyyyyyyyyy much my friend!!
God bless you!
you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks