can I add 4/5 and1/2 to get 6/7 as in 4 of 5 + 1 of 2 and get 6 o

K

kschmoll

I am trying to keep a running total by month of sales vs calls and the data
is entered as 4/5, etc. Is this possible in Excel?
 
E

Eduardo

Hi
try

=TRIM(LEFT(E2,FIND("/",E2)-1))+TRIM(LEFT(F2,FIND("/",F2)-1))&"/"&=TRIM(RIGHT(E2,FIND("/",E2)-1))+TRIM(RIGHT(F2,FIND("/",F2)-1))
 
D

David Biddulph

Yes, entering 4/5 is a possible way of entering either 4th May or 5th April,
depending on your Windows Regional Settings, but it is normally better to
enter data in an unambiguous format.
 
T

T. Valko

Try this array formula** :

=SUM(IF(ISNUMBER(FIND("/",A1:E1)),--LEFT(A1:E1,FIND("/",A1:E1)-1)))&"/"&SUM(IF(ISNUMBER(FIND("/",A1:E1)),--MID(A1:E1,FIND("/",A1:E1)+1,4)))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.
 
B

Bill Sharpe

I am trying to keep a running total by month of sales vs calls and the data
is entered as 4/5, etc. Is this possible in Excel?
Click to expand...
I realize it's not what you asked, but couldn't you have the users enter
the data in two columns: 4 <right arrow> 5
instead of 4/5? Much easier to keep track of without long formulas.

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically sending multiple parts of text from one word doc to another - is possible. 0
Sum of Numbers of a Rolling 6 month Period range 0
HOW-TO make a random selection from a set of data and divide it into sub-team 2
Page numbering with Merged Document and IF statements 1
List all combinations of 6/36 with unique 4 numbers 26
How to reverse code data (1=5, 2=4, etc.)? 5
How to count but exclude overlapping data 1
How to create a dynamic table based on a set of other nested attributes 0

Top