Apache OpenOffice Community Forum

Im new to this and trying to work out a statistic sheet for my company.
I put in informatioen from other data sheet into different page (page2 and onward)
While "page1" is the main where all information is displayed later

I manage without a problem to make as exempel a sum from all columns in a page2 (namned Ark2 (using swedish)) with the
=SUMMA($Ark2.G2:$Ark2.G12)

But when I try to just extend the formula the "page" dont change with it only the "G" column change to as this exempel to G3->G13 instead

So I was thinking to just use the page reference from a cell instead.
As in the picture, I want to reference to the page "Ark4" and cell G2,
=Ark4.G2 (this works)
But instead I wanna use the info in the Cell B5, and read from that page
In my mind
=(Cell B5).G2 but I cant find any workaround for this.

Is it possible to read from a page indicated from a cell?

It is possible to build cell references from text in other cells with the INDIRECT() function, but it is not very convenient. The attached file shows examples on Sheet1, rows 2 and 3. I calculate sums of values on Sheet2 and Sheet3, putting the sheet name in column A and building the formula in column B.
What you are struggling with is probably a result of spreading your data over multiple sheets. On Sheet4 of the file, I condensed the data from Sheets 2 and 3, using column F to label the data. In real data, column F would not say "Sheet2" but would have an informative label. If Sheet2 was separate because it held data from January, then column F of Sheet4 would contain January for those rows. There are formulas on Sheet1 that use the labels from Sheet4's column F to sum subsets of the data. I used SUMIF() and SUMPRODUCT(). I prefer SUMPRODUCT(), but eitherone works. This is a much cleaner way to handle the data. New values and labels can be added to the data set without needing to change the formula structure.

Thanks alot! This helped so much.
I changed some data to the data sheet, but also used the INDIRECT() function to pull data from the data sheet to my main display sheet.

Thanks!