SUMPRODUCT may help you. Please post some more details like what are your
ranges etc.


"Rebecca" wrote in message
...
I am working with a spreadsheet where I need to lookup a text value in one
column and sum the numbers appearing in another column. Is there a way to
combine these two functions? I've figured out how to do the lookup, but
not
how to sum the results. It appears that the lookup stops at the first
match.
Any suggestions would be appreciated.

Thanks!
Rebecca