Count Function
 

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!

Count Function
 

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!

Count Function
 

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!

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!

Count Function
 

PABHL

Try this:

For a list of value in A1:A30

Count of "rescheduled"
B1: rescheduled
C1: =COUNTIF($A$1:$A$30,B1)

Count of "UTC"
B2: UTC
C2: =COUNTIF($A$1:$A$30,B2)
etc

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"PABHL" wrote:

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!

Count Function
 

Just use

=COUNTIF(A1:A30,"rescheduled") etc

--
Allllen


"PABHL" wrote:

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!

Count Function
 

Thanks! Appreciate all the help

"Ron Coderre" wrote:

PABHL

Try this:

For a list of value in A1:A30

Count of "rescheduled"
B1: rescheduled
C1: =COUNTIF($A$1:$A$30,B1)

Count of "UTC"
B2: UTC
C2: =COUNTIF($A$1:$A$30,B2)
etc

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"PABHL" wrote:

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!