ps. Hit escape after you've see the array.

Or hit Ctrl-z (edit|undo) to get the formula back to what it was.

Michael R wrote:

Ha, I solved on epart of the challenge: ctrl-shift-enter makes the formula
work with a range

Still I am not sure about the Sum(...)

"Michael R" wrote:

Ron,

That's a very interesting solution. I do not fully understand what the
{"yes", "na"} does and why a SUM(..) is required around the COUNTIF. Would
you mind teaching me, please?

I tried substituting the list in your formula {"yes", "na"} by a range eg
{D1:D2} where these cells would hold the values "yes" and "na". but that
wouldn't work.

Is there a way how to apply this extended flexiility to your formula?

"Ron Coderre" wrote:

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




--

Dave Peterson