|
|
|
|
#1
11-20-2017, 12:09 PM
|
|||
|
|||
=VALUE(LEFT($A2,Find("/",$A2)-1))+VALUE(LEFT($B2,Find("/",$B2)-1))
=VALUE(MID($A2,Find("/",$A2)+1,100))+VALUE(MID($B2,Find("/",$B2)+1,100)) 
|
|
| Tags |
| excel 2016, sum |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Split function in Excel (split the screen) | Officer_Bierschnitt | Excel | 1 | 07-05-2017 07:02 AM |
| how to split pst file | luk | Outlook | 0 | 11-24-2014 10:18 AM |
| Split a paragraph | bnyamin | Word VBA | 13 | 10-05-2014 08:18 PM |
| How to split .pst file | annabrown8812 | Outlook | 1 | 10-03-2013 04:27 AM |
| Split a task | fridos | Project | 2 | 05-30-2011 11:19 AM |
Windows 8 
Office 2016
Hybrid Mode