Hi
{=COUNT(--ISNUMBER(G95:G98))}, an array formula, counts the range
whether or not the data is a number, just like COUNTA

Peter

"Dave F" wrote:

OK, I figured this out. COUNT counts ALL the 1s and 0s that the -- returns.
Not just the 1s. Duh.

Apologies.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Dave F" wrote:

G95 = 1
G96 = e
G97 = 2
G98 = 3

The count of numbers should be 3. However, I get 4. G96 is formatted as
General. =ISNUMBER(G96) resolves to FALSE.

So???
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.