Previous Topic Next Topic

Excel forumlas

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 -
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

=COUNTIF(E8:E14,"yes")
1
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Answer 2 / 2
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
use a countif function
Ask a question