Thread: Split sum of one single row
View Single Post
 
Old 11-20-2017, 12:09 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
=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))
Reply With Quote