Thanks for the feed-back.
However, if you're going to use this on *large* datalists, since your
original formula used full column references (B:B), use this formula
instead, which reduces the number of functions within the formula and may
run a little faster:
=SUM(IF(ISNUMBER(SEARCH("rectang",A1:A1000)),B1:B1 000))
Also array entered with CSE.
--
Regards,
RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------
"Scorpvin" wrote in
message ...
Ragdyer-
You're are truely the array king! I appreciate all your help.
Everyhthing works like I imaged it. Thanks!
--
Scorpvin
------------------------------------------------------------------------
Scorpvin's Profile:
http://www.excelforum.com/member.php...o&userid=27678
View this thread:
http://www.excelforum.com/showthread...hreadid=471902