That did it! It was not as simple an answer as I thought it would be. I NEVER would have figured it out. Thanks Lei! You saved me!
I learned: you can't do math using the count function. Use IFF to assign 0 or 1 to "no" and "Yes" and then use the SUM function. Works great!