I have several spreadsheets in Adagio Fx and am trying to have one of the sheets summarize the accounts which are on various other sheets within the report (summarizing three companies into a consolidated report (Cannot import and use just one report, as the companies do not have similar account structures, and two require foreign exchange revaluations).

I am using the syntax =querysheet("sheet name","cell ref")which should return the number that is in that worksheet at that cell reference, from what I understand, but I keep getting numbers that bear no relationship to the numbers that are in that cell. The worksheet I am trying to reference is a roll-up, and I am wondering if that is having an effect on the cell reference, however the number I am receiving is not any one of the numbers of the accounts when I do a roll down on the data?

My reseller does not know the answer to this problem either