Try this then:

=SUM(IF(NOT(ISERR(SEARCH("rectang",A1:A1000))),B1: B1000))

Also array entered.

Will work if "rectang" is anywhere within the cell!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Scorpvin" wrote in
message ...

What if I have text before and after such as:

One Rectangle
Five Rectang Three

I would think I need some sort of a wildcard character like *Rectang*


--
Scorpvin
------------------------------------------------------------------------
Scorpvin's Profile:
http://www.excelforum.com/member.php...o&userid=27678
View this thread: http://www.excelforum.com/showthread...hreadid=471902