Hi,
try
=sumproduct(--(B16=B2:B15),C2:C15)

"dc04wrightl" wrote:

Hello,
i have set up a fantasy team within my football club depending on total
goals scored, the table at the top of my design shows all the players and the
goals scored. below is the fantasy team that player 1 made. is there a way of
returning the scores in c16 depending on the player that is listed in b16,
which refers to the main table scores, so it can quickly caculate that total.
thanks, lyndon.

Here is the file:

http://rapidshare.com/files/25304667...Team.xlsx.html