Totaling columns of text in Excel

[Guest]

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

 

[Paul B]

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

 

[Guest]

Yes, it worked perfectly, Thanks!
Classy D

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

 

[Paul B]

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