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...

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,worksheet-function,sumifs,excel-indirect

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

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-indirect

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

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...

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,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....