Forum Discussion
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 ...
Looks like your data is getting converted to text and therefore does not result into a numerical summation. Try using Value function around Index to convert the data into numerical and then use sum as you are doing.
=VALUE(INDEX(your index array and match))