Hello,
Ive been block out for this one task of checking results from the huge
workbooks from different departments...full of stress and pressure...

here's my data from Row 2..
COL A COL B COL C COL D
Results as data numbers names =ISerror(ERROR.TYPE(data))
#N/A 1 AA FALSE
ggg 1 BB TRUE
#N/A 1 CC FALSE
#NULL! 1 AA FALSE
#NULL! 1 BB FALSE
#REF! 1 CC FALSE
2 1 AA TRUE
#REF! 1 BB FALSE
A100 1 CC TRUE
#NUM! 1 AA FALSE
#NUM! 1 BB FALSE
1 CC TRUE
1 1 AA TRUE
#NUM! 1 BB FALSE
#DIV/0! 1 CC FALSE
#DIV/0! 1 AA FALSE
#VALUE! 1 BB FALSE
0 1 CC TRUE
#VALUE! 1 AA FALSE
#NAME? 1 BB FALSE
-1 1 CC TRUE
#NAME? 1 AA FALSE
--------------

may someone share a simple formula lets say on A1 I will type a name e.g.
"AA", and then on B1 i may type the Error.type (1 to 7 only),
and then on C1 i need your formula to bear the sum of Col B *numbers* as per
kinda criteria of "col A= A1", and "col B=B1".

regards with kindness,
driller not *killer*
--
*****
birds of the same feather flock together..