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?
is entered as 4/5, etc. Is this possible in Excel?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
can I add 4/5 and1/2 to get 6/7 as in 4 of 5 + 1 of 2 and get 6 o
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))
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.
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.
=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 realize it's not what you asked, but couldn't you have the users enterI 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?
the data in two columns: 4 <right arrow> 5
instead of 4/5? Much easier to keep track of without long formulas.
Bill