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

  • Thread starter Thread starter kschmoll
  • Start date Start date
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?
 
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))
 
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.
 
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.
 
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

How to reverse code data (1=5, 2=4, etc.)? 5
Sum value in all columns that their title is the same 1
Getting the Last 4 values in a row? 5
total duplicates, remove originals, and add to foot of spreadsheet 5
4 and 5 week months 15
Add number 7
Visual to copy format one row down when data entered 1
Splitting multiple cell contents from 1st column into 4 columns 3

Back
Top