Add string occurences
 

Hi,

I have a column of names, after the names I have either a yes or a no
in the next column. I'd like to add up the number of yeses and nos and
place these two results in two different cells.

How do I do this:confused:

Any help would be greatly appreciated.

Regards,

Shane


--
ofey
------------------------------------------------------------------------
ofey's Profile: http://www.excelforum.com/member.php...o&userid=23866
View this thread: http://www.excelforum.com/showthread...hreadid=375063

Add string occurences
 

If the Yes/No values are in columns B:

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

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=375063

Add string occurences
 

Wow that was a fast answer.

Thank you very much Ron. That's exactly what I was looking for and it
works perfectly.

Thanks again,

Shane


--
ofey
------------------------------------------------------------------------
ofey's Profile: http://www.excelforum.com/member.php...o&userid=23866
View this thread: http://www.excelforum.com/showthread...hreadid=375063