Works great. Thank you

"Pete_UK" wrote in message
oups.com...
I think if the word does not exist then you want to return a zero, so
you need to re-arrange your formula. Something along the lines of:

=IF(ISERROR(MATCH(Sheet2!A2,Sheet1!B1:B10)),0,SUM Formula)

Hope this helps.

Pete