Sumproduct and wildcards

[GregR]

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

[Brian Taylor]

You could try using an array formula:

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

[GregR]

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

[Dave Peterson]

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

[GregR]

Dave, thanks again for your help