Thread
:
Totaling columns of text in Excel
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Classy D
Posts: n/a
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
Reply With Quote