View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bigbilliard bigbilliard is offline
external usenet poster
 
Posts: 1
Default Countif Function in Two Columns

I have a little problem I am trying to count the # or occurences in once
column as it relates to a specific object in another. An example is below.

ColumnA ColumnB
LA Cancel
DC Submitted
LA Submitted
CH Reschedule
LP Cancel
LA Submitted
DC Submitted

I want to know in a seperate cell how many times does "Submitted" appear in
ColumnB when "LA" appears in columA (for this example the answer is 2). Any
help would be appreciated. Thanks
--
Bill