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