Thread: Count Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default 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!