Thread
:
Sumproduct and wildcards
View Single Post
#
2
Posted to microsoft.public.excel.programming
Brian Taylor
external usenet poster
Posts: 52
Sumproduct and wildcards
You could try using an array formula:
{=SUM((F36:F41="*IS*Time*")*(I36:I41=2006)*(G36:G4 1))}
Reply With Quote
Brian Taylor
View Public Profile
Find all posts by Brian Taylor