How do I calculate the sum of a series of results gained using the index formula.

[rafferoonie]

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 up blank. What am I doing wrong?

Sum will work when I have a column of figures produced using countif, but not the figures produced by index.

I’m obviously doing something wrong on a basic level.

[ajlittoz]

Obviously your question is about a Calc function, so retag to replace math by calc. Math is the mathematical formula pretty printer used to insert nicely formatted math equations in Writer.

[igorlius]

The range B5:B43 contains the cells where you use =INDEX(...) is that correct?

• If not it might help if you could upload a small example into your question.

[update]
I just created a very small example which sum over values of index and the result looks ok for me.

Or maybe i misunderstood your problem.