I think your quotation marks are wrong. Try this: =INDIRECT("'I:\"&C1&".xlsx'!Average") Assuming that in cell C1 you have a String that you want to be inserted in your indirection Formula....

excel,excel-formula,excel-2013,countif,excel-indirect

The INDIRECT function returns a reference to a range. You can use this function to create a reference that won't change if row or columns are inserted in the worksheet. Or, use it to create a reference from letters and numbers in other cells. =COUNTIFS(cancellations!AG2:AG408,">0",cancellations!AG2:AG408,B1) should work where B1 contains...

if-statement,excel-formula,excel-indirect

I did the following: On Sheet 1 i gave all the rows a unique number in column A On sheet 2 i just put in the unique number(C23) and the rest of the cells on that row used the formula below with. The only thing i needed to change was...

Assuming you won't have any gaps perhaps try counting the number of month between the first month and the current one, e.g. =DATEDIF(FIRSTMONTH,CURRMONTH,"m")+1...

excel,concatenation,excel-indirect

You are trying to use Concatenate to append all cells in a range. That will not work. Concatenate needs individual arguments, not a range. For such a comparison you would need an array formula. Select all cells from C7 down to C100 (or however many rows you will need for...

excel,excel-formula,worksheet-function,sumifs,excel-indirect

Please try: =SUMIF(INDIRECT("'ITEMS CONTROL'!$B$2:$B$20000"),B$1,INDIRECT("'ITEMS CONTROL'!$C$2:$C$20000")) ...

excel,excel-formula,excel-indirect

I found this formula, while wordy, achieved the desired results. In this example, the data lives in C2:O19. The table I wanted to construct computed the correlation values of all permutations of pairs of columns. Since there are 11 columns, the correlation pairs table is 11x11 and starts at R10....

excel,range,cell,excel-indirect

This will do what you want: =M3/SUM(INDIRECT("M" & $A$1 & ":M" & $B$1)) Not sure if you want A1 and B1 absoluted so I did it anyway....

excel,excel-formula,excel-indirect

Try this formula: =COUNTIF(INDIRECT("'"&D85&"'!R:R");B98) ...