Forum Discussion
JoeCavasin
Mar 26, 2019Brass Contributor
Addition resulting in 0 after using formula to remove alpha characters
Need assistance if possible. I have a data set that is exported as digits, preceded by a letter, in this case F. This export format is hard wired into the program, so the alpha/numeric combo will r...
Twifoo
Mar 26, 2019Silver Contributor
If the addends are in F2:I2, the formula in J2 is:
=SUMPRODUCT(—F2:I2)
The double negatives before the range converts the values therein to numbers.
=SUMPRODUCT(—F2:I2)
The double negatives before the range converts the values therein to numbers.