Wildcards

[irresistible007]

Is it possible to use Wildcard characters in SumPorduct? here sumproduc
is supposed to act as alternate to conditional summing

 

[Guest]

Hi

Here's one way:
=SUMPRODUCT((F7:F13)*(ISNUMBER(FIND("rt",E7:E13))))
will sum F7:F13 where there is "rt" somewhere in E7:E13

Hope this helps.
Andy.

"irresistible007" <[email protected]>
wrote in message
news:[email protected]...

 

[Roger Govier]

Hi

You can use something like
=SUMPRODUCT(--(ISNUMBER(SEARCH("a*a",A1:A10))))
to find any sequence of the letters "a" and "a" with any character in
between, anywhere within the cells.

Regards

Roger Govier