If sumproduct can't use wildcards how do I adjust this formula to
produce the desired results:

=SUMPRODUCT(--(F36:F41="*IS*Time*"),--(I36:I41=2006),(G36:G41)). TIA

Greg

You could try using an array formula:

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

Brain, the result was all of 2006. It did not filter for "IS Time" only

You're looking for "is time" in F36:f41??

=SUMPRODUCT(--isnumber(search("is time",F36:F41)),--(I36:I41=2006),(G36:G41))


GregR wrote:

If sumproduct can't use wildcards how do I adjust this formula to
produce the desired results:

=SUMPRODUCT(--(F36:F41="*IS*Time*"),--(I36:I41=2006),(G36:G41)). TIA

Greg

--

Dave Peterson

Dave, thanks again for your help