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