Reply to thread

Message: [QUOTE="Bob Bridges, post: 3784235"] Bonjour, Vercingetorix (de nouveau)! I'm a little suspicious about whether you mean what you seem to have said, so first let me rephrase it and see whether you still agree: If "name1" is in page2!$A$1:$A$100 and "name2" is in page2!$B$1:$B$100 then SUM(page2!$C$!:$C$100) Is that right? Because I gotta wonder whether you don't mean you want to sum ONLY the items in col C that belong to the right name1 and/2 name2. But if the above is what you really want, then it's pretty simple: IF(OR(ISERROR(MATCH("name1",page2!$A$1:$A$100,0)),ISERROR(MATCH("name2",page2!$B$1:$B$100)),0,SUM(page2!$C$!:$C$100)) Breaking that down into pieces: IF( OR( ISERROR( MATCH("name1",page2!$A$1:$A$100,0) ), ISERROR( MATCH("name2",page2!$B$1:$B$100,0) ), 0, SUM(page2!$C$!:$C$100)) MATCH returns either a (relative) line number where the name was found, or #N/A; therefore ISERROR(MATCH...) returns TRUE if the name was not found, FALSE if it was. OR(ISERROR(),ISERROR()) returns TRUE if either MATCH failed, FALSE if both succeeded (ie both names were found). So IF(OR(...),0,SUM(...)) gives you a 0 in this cell if either name was not found, or the sum of the whole col C if both were there. Is that really what you wanted? [/QUOTE]