View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default {=COUNT(--ISNUMBER(G95:G98))}

You've got 3 cells with TRUE (which you've converted to 1), and one cell
with FALSE (which you've converted to zero).
Zero and one are both numbers so are counted by the COUNT() function.

If you did =COUNT(G95:G98) you presumably get 3?
--
David Biddulph

"Dave F" wrote in message
...
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.