View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Brian Taylor Brian Taylor is offline
external usenet poster
 
Posts: 52
Default Sumproduct and wildcards

You could try using an array formula:

{=SUM((F36:F41="*IS*Time*")*(I36:I41=2006)*(G36:G4 1))}