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 ...
Demo formula in German:
INDEX('tabelle1'!$B$77:$M$77;;C1)+INDEX('tabelle1'!$B$70:$M$70;;C1)
Demo Formula in englisch:
INDEX('tabelle1'!$B$77:$M$77,,C1)+INDEX('tabelle1'!$B$70:$M$70,,C1)
Think this will solve your problem.
I would be happy to know if I could help.
I wish you a long life with health, joy and love.
Nikolino
I know I don't know anything (Socrates)
INDEX('tabelle1'!$B$77:$M$77;;C1)+INDEX('tabelle1'!$B$70:$M$70;;C1)
Demo Formula in englisch:
INDEX('tabelle1'!$B$77:$M$77,,C1)+INDEX('tabelle1'!$B$70:$M$70,,C1)
Think this will solve your problem.
I would be happy to know if I could help.
I wish you a long life with health, joy and love.
Nikolino
I know I don't know anything (Socrates)