Excel forumlas

Closed
Shelly - Jun 1, 2010 at 05:16 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jun 1, 2010 at 05:23 PM
Hello,



I have a column that contains "yes" or "no". I need to total the "yes" in each column. What is the formula to do this?

Thanks

2 replies

=COUNTIF(E8:E14,"yes")
1
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jun 1, 2010 at 05:23 PM
use a countif function
0