Simon, as Alan pointed out "Your illustration referred to "JoeB"; the
formula referred to "Joe B". " where my formula has a space between Joe and
B, if that is the case just delete the space and it should work if the
formula is one the same sheet, I missed the part about "another spreadsheet"
so if you wnat the formula on another sheet try this
=SUMPRODUCT(('Incoming Calls'!A2:A10="Joe B")*('Incoming
Calls'!B2:B10="Complaint"))
if its in another workbook you will also have to refrence the workbook like
this
=SUMPRODUCT(('[Book2]Incoming Calls'!A2:A10="Joe B")*('[Book2]Incoming
Calls'!B2:B10="Complaint"))
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
