Hi,

You may need to create a helper column in each on the monthly spreadsheets
with one cell that contains both the first name and surname. Then in your
summary sheet you could do a vlookup and get the monthly score for each
player for each month.

Hope this helps.

Sean

"sonic-the-mouse" wrote
in message ...

I have set up a spreadsheet for a local squash league.

There are 12 worksheets, 1 for each month of the year, named
accordingly.
In Column A is the players first name, Column B their surname and in
Colum K their score for the month. (In between is game scores)

What I am trying to do is set up a running total for all competitors so
that at the end of the year I will have everyones monthly score and
total score over the year.

I have listed the player names (first and surname) in column A of
another worksheet, totalscores!, which has columns for each month.

I was wondering what formulae to use to search through the worksheets
to find the player in the monthly worksheet and return their score at
the end of the month.

Any help appreciated in advance.

stm


--
sonic-the-mouse