Count Function
=COUNTIF(A:A,number_for_utc)
etc.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"PABHL" wrote in message
...
Thank you so much for your help although I don't think I was too clear in
my
original question. What I was hoping to do was find a way to generate an
individual total for each of the 3 options... so for example out of 500
subjects how many were 'rescheduled' (N = some number), 'utc' (N = some
number), or 'other'. I think my original post made it sound as though I
wanted to total all of the categorical data together within a column-
sorry
for the confusion!
Take care,
"Ron Coderre" wrote:
Try this:
For a list of value in A1:A30
This formula returns the count of items equalling "rescheduled","UTC",
or
"Other":
B1: =SUM(COUNTIF(A1:A30,{"rescheduled","UTC","Other"}) )
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"PABHL" wrote:
I am trying to figure out a way to insert a function that will count
the
categorical data within a column. For example in a column titled
'outcome' I
would like to tally how many people were in one of the following 3
conditions: 'rescheduled', 'UTC', 'Other' Suggestions would be
greatly
appreciated!
|