I am running SUMPRODUCT with 3 criteria, 2 are on another sheet and one
of those two is searching for a portion of the cell content. I am
getting #N/A as the result. Can anyone tell me why?

Here is my formula:

=SUMPRODUCT(ISNUMBER(SEARCH(" - D",'Discussed vs
Opened'!A1:AS1))*('Discussed vs
Opened'!C2:C1512=Summary!A3)*('Discussed vs Opened'!E2:AS1512="Yes"))

The first criteria is the one that contains only a portion of the cell
content and I'm wondering if the "-" is throwing it off. The criteria
reference in the second is a person's name (Summary!A3).

I hope this makes sense and that someone can help!!

Thanks!


--
dcd123
------------------------------------------------------------------------
dcd123's Profile: http://www.excelforum.com/member.php...o&userid=25396
View this thread: http://www.excelforum.com/showthread...hreadid=473799