That sorted that one!

Thanks Squeaky

"Squeaky" wrote:

Hi Gotroots,

What do you get in the cell when there is no text result?

If you get a blank try:

=COUNTA(A1:A10)-COUNTIF(A1:A10,"")

This counts all entries then subtracts the blanks.

The entry "" at the end can be changed to whatever you get when there is no
text.

Squeaky

"Gotroots" wrote:

What formula do I need to count a range where the cells contain a formula.
The cell range formula returns a text value.

example:

A1:A10 contain a formula that will return a text result

A11 contains a formula to return the number of cells that have a result in
in A1:A10 Any formulas I have tried count the formulas also.