View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve
 
Posts: n/a
Default Sumif or Sumproduct? Maybe neither?

Column B has a formula result of either "DUP", "NoDup" or it is blankk "".
Column M has text entries of either "Y" or "N". I would like to get a count
of how many times "NoDup" and "Y" appear in the same row.

Any help is always appreciated.

Steve