The COUNTIF function can do this. E.g,.

=COUNTIF(A1:A10,"x")

will return the number of "x" entries in the range A1:A10.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com



On Thu, 15 Apr 2010 08:33:01 -0700, Jcdc
wrote:

I have a spreadsheet where I need to tally the number of Yes, No and N/A
anwsers. How can I add them if the letter
"x" is being used to mark the answer?