I have tried setting a COUNTA formula on an array. The cells in the array
all have a similar formula in each one and will contain text if a specific
condition is met in another set of cells. The problem I am getting is that
when I put in the formula =COUNTA(A1,B1,C1), I get the result of all of them
not being empty. Is this because all those cells contain formulas, even if
text is there or not. If so, is there a similar function to COUNTA that will
count cells and not take into account that a formula is already in the cell?

Any help will be appreciated.

Steve