whatever formulas you have will work best/fastest if all data is in the same
workbook. I usually have a worksheet in the active workbook that updates
certain columns or information from individual sheets when it opens. Then
all the data is in the workbook, ready to work with.

"Ragdyer" wrote:

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