View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default {=COUNT(--ISNUMBER(G95:G98))}

But =SUMPRODUCT(--ISNUMBER(G95:G98)) resolves correctly.

Color me confused.
--
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.