count - but exclude counting cells with a formula
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.
|