Hi,

I'm not quite sure why you say this won't work. As I understood the original problem your COUNTA was not ignoring a blank result in a cell since the cell itself contained a formula which is regarded by the COUNTA as being a 'value'. The COUNTIF() should return the count of all non blank cells and if I understand your problem will return a value one less than the COUNTA formula (assuming one blank result in the range looked at).

Substituting the COUNTIF() for your COUNTA() should return a different result.

Rgds