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