Thread: Countif? or Vlookup? Lost??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default Countif? or Vlookup? Lost??
Leo,

=SUMPRODUCT((A2:A5="North")*(B2:B5="PSR")*(C2:C5=" Yes"))

- John
www.JohnMichl.com

Reply With QuoteReply With Quote