0

I have a countif formula that gathers information from another sheet.

=SUM(COUNTIFS(test!A:A,{"Story","Task"},test!D:D,{"In Progress"}))

The sheet is named test.

Is there any way I can write test in another cell and reference it in the formula?

Eg: Cell A3 = test

=SUM(COUNTIFS(A3!A:A,{"Story","Task"},A3!D:D,{"In Progress"}))
0

The function to use is INDIRECT

So A3=test will be =indirect("A"&"3")
That is because INDIRECT returns the cell reference using the two parameters concatenated by &.

In your formula A3 becomes the first parameter and A:A the second, resulting to:

=SUM(COUNTIFS((indirect(A3&"!"&"A:A"),{"Story","Task"}, 
              (indirect(A3&"!"&"D:D"),{"In Progress"}))

You can read more about INDIRECT.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.