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"}))

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"}))