{=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.
|