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!
|