Sum right numbers (after dash)

[used2reg]

I have cells that i am trying to add....

A1 - FEB 16 - 60
B1 - FEB 17 - 45
C1 - Feb 18 - 120

The cell has a date, then a dash and then a number -I would like to be able to add the numbers after the dash. So for the 3 listed above it would sum 60+45+120 = 225...

Thanks

 

[philwojo]

I'm sure there is a better way to do this, but try this:

=MID(A1,(FIND("-",A1)+2),3)+MID(B1,(FIND("-",B1)+2),3)+MID(C1,(FIND("-",C1)+2),3)

 

[Weazel]

maybe...

=SUMPRODUCT(0+REPLACE(A1:C1,1,FIND("-",A1:C1)+1,""))