How can you get around the count function seeing formulas in any cell
referenced as data?

I don't think COUNT will, COUNT yes, but not COUNT unless it returns a
number.

Give an example.

--

HTH

Bob

"robinessex" wrote in message
...
How can you get around the count function seeing formulas in any cell
referenced as data?

Hi,

I don't understand the question. Perhaps if you tell us what you are trying
to count and the types of data in the cells being counted someone will help.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"robinessex" wrote:

How can you get around the count function seeing formulas in any cell
referenced as data?

I'm sure Bob meant =CountA() will count cells with formulas.

=Count() will count cells with formulas if the formulas evaluate to a number.

Bob Phillips wrote:

I don't think COUNT will, COUNT yes, but not COUNT unless it returns a
number.

Give an example.

--

HTH

Bob

"robinessex" wrote in message
...
How can you get around the count function seeing formulas in any cell
referenced as data?

--

Dave Peterson

count function counts the data exist cells
counta function counts the cells with formula cum data cells
countblank function counts blank cells.

all the best