How do I add the 'yes' answers in a column using Microsoft Excel?

[nana]

This has been bugging me for nights. I do not know what function to use or
formula to total the number of 'yes' answers in a column using Microsoft
Excel. I only know how to total numbers in Excel but not the text. I am
making a marketing report of clients whom we called and one of the colums has
a heading of Enrollment. Answers to this column can either be Yes or No.
How do i total the number of 'Yes' or enrolled clients at the end of the
column. PLEASE HELP!! SOS!!!

 

[Ofer Cohen]

You have posted your question in Microsoft Access Discussion group, there is
a Discussion group dedicated to Microsoft Excel at this link:

http://www.microsoft.com/office/com...?dg=microsoft.public.excel.misc&lang=en&cr=US

 

[John Vinson]

This has been bugging me for nights. I do not know what function to use or
formula to total the number of 'yes' answers in a column using Microsoft
Excel. I only know how to total numbers in Excel but not the text. I am
making a marketing report of clients whom we called and one of the colums has
a heading of Enrollment. Answers to this column can either be Yes or No.
How do i total the number of 'Yes' or enrolled clients at the end of the
column. PLEASE HELP!! SOS!!!

You're asking in the wrong place. This newsgroup is not for Excel;
it's for a different program, Microsoft Access. Please scroll down the
list of subject areas and repost in an Excel support area.

You should be able to use the IF() function to get a 1 for "yes" and a
0 for "no" answers, and sum that up. See the online help for IF.

John W. Vinson[MVP]

 

[BobMartin776]

This has been bugging me for nights. I do not know what function to use or
formula to total the number of 'yes' answers in a column using Microsoft
Excel. I only know how to total numbers in Excel but not the text. I am
making a marketing report of clients whom we called and one of the colums has
a heading of Enrollment. Answers to this column can either be Yes or No.
How do i total the number of 'Yes' or enrolled clients at the end of the
column. PLEASE HELP!! SOS!!!

Use the COUNTIF function in Excel: =COUNTIF(CellRange,"Yes")
where CellRange is the range of cells you want to include in your search.
Check for complete details in Excel help.
Bob