Hi,

I am trying to count the number of non-blank cells in column DF (of the Master worksheet) for values in column DA (of the Master worksheet) that match the criteria in cell B4 (of the 2013 List sizes worksheet). I have the formula as per below but its not giving me the correct result. Can someone point me in the right direction?

=COUNTA(IF(MASTER!DA:DA='2013 List sizes'!B7,MASTER!DF:DF))

The answer should be 4 but it returns 65536.

Any assistance would be appreciated!

Thanks.