Use COUNT.IF and INDIRECT together

Question

I'm trying to use a function that uses COUNT.IF and INDIRECT at the same time.

=COUNT.IF('Sheet1'!$D$3:INDIRECT("MA" & E4);1) 

seems to work but

=COUNT.IF('Sheet1'!INDIRECT("D" & E5):INDIRECT("MA" & E6);1)

doesn't. Does anyone know how to solve this ? Thanks !

Answer 1

You may try

=COUNTIF(INDIRECT("'Sheet1'!D" & E5 & ":MA" & E6),1)