Cell reference within INDIRECT formula

[cpg84]

Hi,

I have the following formula that works perfectly:

=IF(SUMPRODUCT(COUNTIF(INDIRECT("'"&A20:A54&"'!H14"),">0"))=0,0,SUMPRODUCT(COUNTIF(INDIRECT("'"&A20:A54&"'!H14"),">0"))-(35-COUNTA(F20:F54)))

I just want to know how to change the H14 so it can be changed to a cell reference. I want to type in a number in a separate cell so the "H14" will change depending on what is in that cell e.g. If the cell says 13, the formula below will change to "H13".

COUNTIF(INDIRECT("'"&A20:A54&"'!H14"),">0")

Is this possible?

 

[JasonDJ]

=if(sumproduct(countif(indirect("'"&a20:a54&"'!h"&h14),">0"))=0,0,sumproduct(countif(indirect("'"&a20:a54&"'!h"&h14),">0"))-(35-counta(f20:f54)))