How to count only number entry & errors from the data ?

[ASHISH076]

Hi,

Please provide me any formula for counting Numbers & errors from the value

Below are the set of data, also attached file of excel

Name A. Count of Numbers from Data ?
ASHISH B .Count of Errors from Data ?
JACK
ROSE
ROSE76
#N/A
76
79
0
#
$
*
1MS
#NAME?
#VALUE!
#DIV/0!
#N/A
TRUE
TRUE
FALSE
{1,2;3,4}


Regards
ashish
"Success is not Permanent and Failure is not Final"

 

[pecoflyer]

Like this ? ( using array functions that have to be committed with Ctrl+Shift+Enter)

 

[ASHISH076]

THANKS

 

[pecoflyer]

On second thought we can do without those clumsy array formulas

=SUMPRODUCT(--(ISNUMBER($B$5:$B$24)))
=SUMPRODUCT(--(ISERROR($B$5:$B$24)))

 

[Colin Legg]

To get the numeric count you could use:

=COUNT(B5:B24)