Yes No

G

Guest

Can I write a formula in which "yes" equals 1 and "no" equals 0. So when
completed I have a sum of "yeses".
 
G

Guest

How about using the COUNTIF function?

=COUNTIF(A1:A100,"yes")

This would count the number of times that "yes" appears in the range A1 thru
A100.

HTH,
Elkar
 
G

Guest

This will give you a 1 if A1 is Yes, and 0 otherwise.
=IF(A1="Yes", 1, 0)

This will give you a count of cells in Column A where the cell value is
equal to "Yes"
=COUNTIF(A:A,"Yes")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to generate a list from a table 1
Need to calculate simple formula for cells 2
Need to calculate simple formula for cells 1
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
divide by zero error 5
counting x instances of a string across columns... 9
Formula with blanks 5
formating an unbound text box 1

Top