Forum Discussion
rafferoonie
Sep 15, 2020Copper Contributor
Problem adding up numerical results from index calculations
I wish to add up the numerical results of a series of index calculations. The index calculation result is showing on the sheet, but when I try and add up the column by typing in sum(b5:b42) it comes ...
SergeiBaklan
Sep 15, 2020Diamond Contributor
You may use double dash to convert texts to numbers
=SUM(--B5:B42)
but better to adjust initial formula to return numbers instead of texts.