I've got 2 columns data like below:

4.40/4.75 1312.96
5.60/5.66 1757.24
6.54/6.70 2121.94

.... so on



Is it possible to do a sumproduct like choosing item from either side of the "/" as per requirement using Formula's and not VBA ?

(4.40 * 1312.96)+(5.66 * 1757.24)+(6.54 * 2121.94)+....

If I had to choose items from the left side of "/" I would use 
=SUMPRODUCT((E1:E5)*--(LEFT($C$1:$C$5,FIND("/",$C$1:$C$5)-1)))
or to choose from after "/" like 
=SUMPRODUCT((E1:E5)*--(MID($C$1:$C$5,FIND("/",$C$1:$C$5)+1,6)))