Wildcards

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


--
irresistible007


------------------------------------------------------------------------
irresistible007's Profile: http://www.hightechtalks.com/m63
View this thread: http://www.hightechtalks.com/t2313075

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]...
>
> Is it possible to use Wildcard characters in SumPorduct? here sumproduct
> is supposed to act as alternate to conditional summing.
>
>
> --
> irresistible007
>
>
> ------------------------------------------------------------------------
> irresistible007's Profile: http://www.hightechtalks.com/m63
> View this thread: http://www.hightechtalks.com/t2313075
>

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


irresistible007 wrote:
> Is it possible to use Wildcard characters in SumPorduct? here sumproduct
> is supposed to act as alternate to conditional summing.
>
>