Assuming you have 3 columns for Yes, No and N/A and they are putting an X in
the relevant column, you can use the countif function for each columns range
e.g.
=COUNTIF(A1:A500,"x")
=COUNTIF(B1:B500,"x")
=COUNTIF(C1:C500,"x")

"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?