converting a countifs referencing part of the formula to a indirect countifs

[DEEARO]

Hi all.

thank you in advance

my formula below is a countifs formula. i want to covert the 'July 21'! part of the formula to be indirect, is this possible?

=COUNTIFS('July 21'!$E:$E,">="&$A$4,'July 21'!$E:$E,"<="&$A$5,'July 21'!$A:$A,$B13,'July 21'!$D:$D,E$3)

thank you in advance

[AliGW]

I think you need to define 'without over completing the formula'.

[DEEARO]

True, any formula will do.

thank you in advance

[DEEARO]

hi all,

is any further information required?

[JohnTopley]

Try

=COUNTIFS(INDIRECT("'" &A1 &"'!$E:$E"),">="&$A$4,INDIRECT("'" &A1 &"'!$E:$E"),"<="&$A$5,INDIRECT("'" &A1 &"'!$A:$A"),$B13,INDIRECT("'" &A1 &"'!$D:$D"),E$3)

A1 contains "July 21" (Text)