Suppose we have following figure in each cells
Rs.50
Rs.20
Rs.60
Rs.10
Etc..
All above data are in charecters..
so, How me Add them All.
Reagrds
amit
2007-01-05 21:07:50 · 4 answers · asked by amitdelpanwar 1 in Computers & Internet ➔ Software
Do you have each cell with Rs.XX value?
Or you have all these values in one cell.
If you have each cell with Rs.xx value, then you will need first to split the numbers, if your list was in cell A1, then paste this in B1
=MID( A1,SEARCH("." ,A1)+1,10)
then SUM this column (B:B)
If it is all in one cell, you will need more than this, mail me here in Y! Answers to do it for you
Enjoy my profile, I am the VBAXLMan
2007-01-07 23:20:22 · answer #1 · answered by Anonymous · 0⤊ 0⤋
Use Text to columns (under Data menu) with Delimited, choosing "Other:" and putting a "." in the field. This will split the text into two columns:
Rs and 50
Rs and 20
etc.
Sum up the column on the right.
= SUM(Col:Col)
2007-01-06 09:35:20 · answer #2 · answered by nospamcwt 5 · 0⤊ 1⤋
Click insert, then function, click sum, click OK
or just click auto sum sign at the top of the toolbar
2007-01-06 05:12:42 · answer #3 · answered by Guess 3 · 0⤊ 1⤋
ooh look, puppies!
2007-01-06 05:12:12 · answer #4 · answered by xx_muggles_xx 6 · 1⤊ 1⤋