Hello again!
I realized the error was that the decimal point is a , (we are using
Spanish localization), so changing the , for a . decimal point did the
trick.
Once again, thank you a lot.
El 05/08/2014 a las #4, Daniel R. Miguel escribió:
Hi again,
I modified the formula to suit my spreadsh
Hi again,
I modified the formula to suit my spreadsheet to
{=SUM(IF(LEFT(B46:AE46,2)="OT",VALUE(MID(B46:AE46,3,99)),0))}. It works
beautifully but, in some instances it will render an Err:502.
One of said instances is this:
OT8 HF8 OT8 OT2 OT1 OT0,5 OT8 OT8 OT8 OT5 OT6 OT5 OT6
OT5
At 17:38 04/08/2014 +0200, Daniel R. Miguel wrote:
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:
AlanOT0,5FOT1FV
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:
AlanOT0,5FOT1FVOT2FFVOT3
I would have ano