What is it that you want to count, text or numbers?

if text but not cells with formulas that return blank ""

=SUMPRODUCT(--(ISTEXT(A1:A10)),--(LEN(A1:A10)0))

if numbers

=COUNT(A1:A10)

if both numbers and text but not blanks from formulas

=SUMPRODUCT(--(LEN(A1:A10)0))


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Steve Jackson" wrote in message
o.uk...
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