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+unsubscr...@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
