yes and no column
 

I am a beginner and I have an audit to do. I will need to add up all of the
yes and no answers which are in a single column

Thank you in advance
ferde

One way ..

Assuming the answers are in col B:

=COUNTIF(B:B,"Yes")
=COUNTIF(B:B,"No")

And if there's the possibility of white spaces creeping into the "Yes" and
"No" answers entered in the column (assuming these were manually input,
say), we could try something like:

=SUMPRODUCT(--(TRIM($B$1:$B$100)="Yes"))
=SUMPRODUCT(--(TRIM($B$1:$B$100)="No"))

The TRIM() will remove all the extraneous leading / trailing white spaces
(if any) for a more robust match

Adapt the ranges to suit. Note that we can't use entire col references (A:A,
B:B, etc) in SUMPRODUCT
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"ferde" wrote in message
...
I am a beginner and I have an audit to do. I will need to add up all of
the
yes and no answers which are in a single column

Thank you in advance
ferde