Thread: Sumif
View Single Post
  #1   Report Post  
RagDyeR
 
Posts: n/a
Default

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