1 column with YES and NO responses. Can we sum for ea. total of YES's and NO's? (Okay to put resul

[StargateFanFromWork]

I just had a rush job to do up an Excel sheet while my supervisor dictated
the data to me as she interpreted the emails/faxes with various responses.
One column in particular had YES and NO as the possible data type. In the
end, I was to total up the number of YES answers and put the total in one
cell; and then to do the same for the NO answers. These YES's and NO's are
all in one column, unfortunately, but the sum of each we put into 2 cells.
Is there a formula that I could have used for each just substituting a value
that would work with the YES answers and another that would return the total
of the NO answers?

I had a filter and because this was a rush just filtered for each and
counted them up and inserted figure manually, but it would be good to
automate this as they'll need to be inputting more data as responses come in
over the next 5 days. Hoping there's a way to deal with the two types of
data.

Thank you!! D

 

[Dave Peterson]

=countif(a:a,"yes")

would count the number of Yes's in column A.

="Total Yes's: " & countif(a:a,"yes") & char(10)
& "Total No's: " & countif(a:a,"no")

all one cell with wrap text turned on would look like this:

Total Yes's: 12
Total No's: 13

But I'd use separate cells to make any further calculation easier.

 

[Ron Coderre]

Try this:
B1: =COUNTIF(A:A,"YES")
B2: =COUNTIF(A:A,"NO")

Does that help?

***********
Regards,
Ron

 

[Cutter]

Use the COUNTIF() function:

=COUNTIF(A1:A100,"YES") to count the YES replies

=COUNTIF(A1:A100,"NO") to count the NO replies

change the A1:A100 to whatever range you use

 

[StargateFan]

Try this:
B1: =COUNTIF(A:A,"YES")
B2: =COUNTIF(A:A,"NO")

Does that help?

Sure does, thank you to you and everyone for your responses! I only
just recently learned about Countif and just didn't realize it could
do something like this, too! Fabulous.

I believe I brought home a copy of the sheet in case there were
responses in this ng. If so, I'll work on it now if that's the case
so that I can re-send a new-and-improved version tomorrow. It will
mean less fiddling for the team.

 

[StargateFan]

=countif(a:a,"yes")

would count the number of Yes's in column A.

="Total Yes's: " & countif(a:a,"yes") & char(10)
& "Total No's: " & countif(a:a,"no")

all one cell with wrap text turned on would look like this:

Total Yes's: 12
Total No's: 13

But I'd use separate cells to make any further calculation easier.

Do you mean that if there were more than 2 types of data to deal with
other than just YES or NO? Makes sense. In this application I should
be safe as it's just the 2 for now (and although management looks to
put monkey wrenches into things, can't see them doing too much more
than YES or NO in this particular instance. In this case, in other
words, so far there can only be an either/or answer. I defy them to