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

#1 (**permalink**) 28-Jul-2006, 08:32 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12867-how-do-i-add-yes-answers.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12867
column. PLEASE HELP!! SOS!!!
--
NANA

*

#2 (**permalink**) 28-Jul-2006, 08:32 AM

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/comm...&lang=en&cr=US

--
Good Luck
BS"D
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12867

"nana" wrote:

> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12867
> 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!!!
> --
> NANA

#3 (**permalink**) 28-Jul-2006, 08:32 AM

On Mon, 10 Jul 2006 08:43:01 -0700, nana
wrote:

>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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12867
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12867
>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]

#4 (**permalink**) 28-Jul-2006, 08:33 AM

"nana" wrote:

> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12867
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12867
> 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!!!
> --
> NANA

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