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...