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

Wildcards
 

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"
wrote in message
...

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

Wildcards
 

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.