| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
Thank you both for your replies, both work :)
"Eduardo" wrote: 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 |
Threaded Mode
