Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Function to count unique items in list | Excel Worksheet Functions | |||
Count function applied to a time period | Excel Worksheet Functions | |||
Function to count unique values? | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions |