Previous Topic Next Topic

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

Answer 1 / 2
seeBlack
Jun 1, 2010 at 05:23 PM
=COUNTIF(E8:E14,"yes")
1
Answer 2 / 2
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