You're welcome! J.E. McGimpsey has some information on SUMPRODUCT:

http://www.mcgimpsey.com/excel/formulae/doubleneg.html


steve wrote:
Debra,

Your solution worked beautifully. Thank you!

I understand the notion of scoring the columns. Now I just need to
spend some time learning about the SUMPRODUCT function so that I
thoroughly understand how your method works!



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html