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

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?

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

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))

"kschmoll" wrote:

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?

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

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.
--
David Biddulph

"kschmoll" wrote in message
...
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?

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

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.

--
Biff
Microsoft Excel MVP


"kschmoll" wrote in message
...
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?

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

On 2/4/2010 9:49 AM, kschmoll wrote:
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?
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