Try this:

=SUM(COUNTIF(A1:A10,{"yes","na"}))

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"cookie's mom" wrote in message
...
having trouble with this - need help on what formula to count the total of
two different non-numeric values in a range, i.e., "Yes" and "NA" - trying
COUNTIF, but having trouble...