Thread: Summarize results from files into main file

Hi,

I am trying to summarize testresults from a number of files into one main file. The results are in the same cell in each file, but the files names differ.

So, what I need is a formula that helps me to scan the files so I don't have to go in and manually check the specific field and then write the result ( a number ) down in the main file.

This is what I'd like it to do:

Y=main file
X1, X2, X3 etc... = files where I want to scan the values

Cell value in file Y = "IF there is a file X in a subcatalog to where Y is located where <string in cell Y.A1> equals the <string in cell X.F1> then give me the value of field X.G1"

The formula must work for more than one file, preferrably for a list of files with values, where I want to sum up the values from all the files in the "main file". The name of the file is written into a specific cell in each file and also in a list in the main file.

Thanks a lot.

Kind regards,

Katarina

You might be able to get the effect you yant using

=INDIRECT(ADDRESS(...))

Mark.

Hello there, sorry for not having posted a reply earlier. I have not tried the other =INDIRECT(ADDRESS(...)) but here is a testfile for someone ( special? just like me... )

Anyway:

In the example file below, the field ('Mainfile Y'!A3) should be checked against ='Example testfile X'!D6. If they are the same, I would like the values from ='Example testfile X'!B17 to be written into ='Mainfile Y'!B3.

It would also be nice if the values of =SUM('Example testfile X'!B19:B20)
were written into ='Mainfile Y'!C3.

And then.. of course, this should be a general formula and Mainfile and Example testfile are actually two different files ( not two tabpages ) that not necessarily are in the same folder ( but this I can change ).


Thanks in advance.

/Katti

Attachment- testfile