The sumproduct function multiplies words?
uhmmm, not really. But it's very powerful. Read up on it in this brilliant article:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

cheers