Thanks to all for the last help; the page took a moderate amount of
figuring out, but the team manager sheet works nicely now.

Naturally, not being able to leave well enough alone, I'd like to
compile stats for the team vs other teams. How do I get excel to look
up multiple instances of a value (opposing team) and return the sum of
the numbers from a column, i.e., you play a particular team 3 different
times in a season and not back to back (unsorted data) how do you pick
out the total (sum) number of touchdowns/whatever that you scored
against them from a table?

Thanks so much for the help,

Mojo


--
mojoshenpo
------------------------------------------------------------------------
mojoshenpo's Profile: http://www.excelforum.com/member.php...o&userid=36495
View this thread: http://www.excelforum.com/showthread...hreadid=562523