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