Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|