Hey all:
First post here, thanks in advance.
I want to pull text from another cell and add it to myformula. For example, I have a formula below where I am referencing a differenttab of the workbook.
=SUMIF(Sheet1!C119:C123,2015,Sheet1!F119:F123)
I would like to be able to modify this formula so that I canreference a cell with “Sheet1” written in it. If we pretend “Sheet1” is in cellA1, in my mind it would like something like this.
=SUMIF(A1!C119:C123,2015,A1!F119:F123)
Any ideas?
First post here, thanks in advance.
I want to pull text from another cell and add it to myformula. For example, I have a formula below where I am referencing a differenttab of the workbook.
=SUMIF(Sheet1!C119:C123,2015,Sheet1!F119:F123)
I would like to be able to modify this formula so that I canreference a cell with “Sheet1” written in it. If we pretend “Sheet1” is in cellA1, in my mind it would like something like this.
=SUMIF(A1!C119:C123,2015,A1!F119:F123)
Any ideas?