Attachment 627964
Hi, i am trying to do this:
=AVERAGEIFS(INDIRECT(D$1);INDIRECT(D$2);">="&$C7;INDIRECT(D$2);"<"&$B7)
In file "scores per day", I want to take the average for the data that is in between the timestamps (which is in column B in file_6). The timestamps basically specify a specific second at a certain day. Each company is in a different sheet, which is why I am using the INDIRECT formula. Column C in file_6 corresponds to the average range. Furthermore I have multiple excel files such as file_6. So the file name in row 4 of the "scores per day" file is different per company as I have multiple files. Therefore please do not only use a reference to file 6 but I need to make sure it refers to row 4 as I did right now. I have about 2000 companies spread across several files and therefore a manual reference is not going to work. I need an indirect reference to the file, sheet and range which is specified for each company. For simplicity I just attached one of the files (file 6) right now that I use to look data up, but I have multiple ones like this.
I have the other files open so the INDIRECT should work. Does anyone know what I did wrong?
Any help would be appreciated, thanks in advance. I also added a file in which I show what I am trying to achieve (but I need an INDIRECT reference to a file, since I have a different file per company).
Bookmarks