Hi Jay,

Am Mon, 11 Nov 2013 13:19:42 +0000 schrieb Jay07:

=SUMPRODUCT((Extract!F$4:F$29783="Y")*(Extract!$BF $4:$BF$29783=Formula!$B5)*(COUNT(SEARCH(Dashboard! $C$3,Extract!$BK$4:$BK$29783,0))))

For the third condition the text to search for is held in another Sheet
(Dashboard) and is in cell C3. The column containing strings of text is
in the Extract worksheet - column BK.

are you searching for the exact word in BK? Then try:
=SUMPRODUCT((Extract!F4:F29783="Y")*(Extract!BF4:B F29783=Formula!B5)*(Extract!BK4:BK29783=Dashboard! C3))

Are you looking for a substring then try:
=SUM(IF((Extract!F4:F29783="Y")*(Extract!BF4:BF297 83=Formula!B5)*(ISNUMBER(SEARCH(Dashboard!C3,Extra ct!BK4:BK29783))),1))
or
=SUM((Extract!F4:F29783="Y")*(Extract!BF4:BF29783= Formula!B5)*(ISNUMBER(SEARCH(Dashboard!C3,Extract! BK4:BK29783))))
The last two formulas have to be array-entered with CTRL+Shift+Enter


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2