Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
SUM(IF( Array to avoid #NUM! values | Excel Worksheet Functions |