Excel forumlas

Closed
Shelly - 1 Jun 2010 à 17:16
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 1 Jun 2010 à 17:23
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
Related:

2 responses

=COUNTIF(E8:E14,"yes")
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
1 Jun 2010 à 17:23
use a countif function