Previous Topic Next Topic

Excel forumlas

Closed
Shelly - Jun 1, 2010 at 05:16 PM
rizvisa1 Posts 4478 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
Related:

2 responses

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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response