View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DocBrown DocBrown is offline
external usenet poster
 
Posts: 119
Default Sumproducct question

Can anyone help with a sumproduct question?

I would like to sum the values in range $N$16:$N$200 if the value in column
E of the row is not a capital letter and column M of the row is blank.

Column E can be blank, one uppercase letter, or lower case letter.

Thanks a bunch
John