Totaling columns of text in Excel
 

I just started working for a non-profit organization that uses Excel for
statistical purposes, to secure funding. Excel would not have been my first
choice for this project, but I can't change the process because I am newly
hired in this position. My spreadsheet contains information taken from Client
Surveys. The data I take from these surveys is "Males and Females" and "yes
and no" other "text" and some numbers as well. I know how to total the number
columns, but I need to be able to total the text columns as well. Any help
would be greatly appreciated.
Thanks
Classy D

Totaling columns of text in Excel
 

Classy D, if you want to count how many males are a range use something like
this, =COUNTIF(A1:A10,"Males") is that what you need?

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Classy D" <Classy wrote in message
...
I just started working for a non-profit organization that uses Excel for
statistical purposes, to secure funding. Excel would not have been my
first
choice for this project, but I can't change the process because I am newly
hired in this position. My spreadsheet contains information taken from
Client
Surveys. The data I take from these surveys is "Males and Females" and
"yes
and no" other "text" and some numbers as well. I know how to total the
number
columns, but I need to be able to total the text columns as well. Any help
would be greatly appreciated.
Thanks
Classy D

Totaling columns of text in Excel
 

Yes, it worked perfectly, Thanks!
Classy D

"Paul B" wrote:

Classy D, if you want to count how many males are a range use something like
this, =COUNTIF(A1:A10,"Males") is that what you need?

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Classy D" <Classy wrote in message
...
I just started working for a non-profit organization that uses Excel for
statistical purposes, to secure funding. Excel would not have been my
first
choice for this project, but I can't change the process because I am newly
hired in this position. My spreadsheet contains information taken from
Client
Surveys. The data I take from these surveys is "Males and Females" and
"yes
and no" other "text" and some numbers as well. I know how to total the
number
columns, but I need to be able to total the text columns as well. Any help
would be greatly appreciated.
Thanks
Classy D

Totaling columns of text in Excel
 

Your Welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Classy D" wrote in message
...
Yes, it worked perfectly, Thanks!
Classy D

"Paul B" wrote:

Classy D, if you want to count how many males are a range use something
like
this, =COUNTIF(A1:A10,"Males") is that what you need?

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Classy D" <Classy wrote in message
...
I just started working for a non-profit organization that uses Excel
for
statistical purposes, to secure funding. Excel would not have been my
first
choice for this project, but I can't change the process because I am
newly
hired in this position. My spreadsheet contains information taken from
Client
Surveys. The data I take from these surveys is "Males and Females" and
"yes
and no" other "text" and some numbers as well. I know how to total the
number
columns, but I need to be able to total the text columns as well. Any
help
would be greatly appreciated.
Thanks
Classy D