View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cheech is Lost Cheech is Lost is offline
external usenet poster
 
Posts: 1
Default Counting instances that 2 different columns match

I am trying to enter a formula to do the following:

I am trying to have one cell count the number of times a name appears in one
column while a value also appears in another alongside of it

Ex:

Column A Column B
Bill 1
Steve 1
Harry 0
Bill 1
Harry 1
Bill 0
Steve 1
........

I am looking for a formula that tells me how many times Bill appears in
column A and 1 appears in column B alongside it (has to be both Bill and 1)

The example above should give me a result of 2

Any suggestions?