View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Classy D
 
Posts: n/a
Default 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