View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stevestock Stevestock is offline
external usenet poster
 
Posts: 1
Default COUNTIF - more complex

I am needing a formula that will count text occurences in multiple columns,
similar to an a COUNTIF statment but using a filter quality. For example, I
need to know for all rows with the name of Joe in one column, how many times
Joe has a case "Open". I am using the 2000 version.