[libreoffice-users] Sum of multiple cells substring

Hi, I have a table with cells that may contain OTnum, so it might 
contain OT0.5, OT1, OT2, OT2.5 et cetera.

I would want to sum the number substring of all the cells in a row, so 
for example if I have this row:

Alan    OT0,5    F    OT1    F    V    OT2    F    F    V    OT3

I would have another column with the total sum of OT:

Alan    OT0,5    F    OT1    F    V    OT2    F    F    V    OT3 6,5 
(OT3+OT2+OT1+OT0.5)

I have tried with the formula 
=SUMPRODUCT(MID($B5:$AF5,FIND("OT",$B5:$AF5,3))), but I am not actually 
sure what I am doing.

Thanks.

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted