Ron,
Bingo! Worked perfectly. I had studied that formula but the description did
not seem to fit. Thanks a milion! You just shortened my workday and I can go
home on time. Have a nice evening yourself.

Roger Hockett


"Ron Coderre" wrote:

Try the SUMPRODUCT function, I believe it will do what you're asking.

Example:
=sumproduct(C12:C100,U12:U100)
Tha will multiply corresponding Cs and Us and add the products.

Regards,
Ron