Thread: Count IF Q
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Sean is offline
external usenet poster
 
Posts: 454
Default Count IF Q

One small twist on this, how could I list the names of the locations
(which are in Z8:Z33) that have Zero sales and Zero Stock, in a string
format. eg. "London, Manchester, Bristol" etc