software

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

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

quot;sonic-the-mousequot; gt; wrote
in message ...
gt;
gt; I have set up a spreadsheet for a local squash league.
gt;
gt; There are 12 worksheets, 1 for each month of the year, named
gt; accordingly.
gt; In Column A is the players first name, Column B their surname and in
gt; Colum K their score for the month. (In between is game scores)
gt;
gt; What I am trying to do is set up a running total for all competitors so
gt; that at the end of the year I will have everyones monthly score and
gt; total score over the year.
gt;
gt; I have listed the player names (first and surname) in column A of
gt; another worksheet, totalscores!, which has columns for each month.
gt;
gt; I was wondering what formulae to use to search through the worksheets
gt; to find the player in the monthly worksheet and return their score at
gt; the end of the month.
gt;
gt; Any help appreciated in advance.
gt;
gt; stm
gt;
gt;
gt; --
gt; sonic-the-mouse

Hi Sonic,

Working on the basis that all your work sheets are in one workbook and
that each page has the data on it laid out in the same cells and that
the monthly total appears in the same cell on each work sheet, you can
SUM through the sheets.

In the summary sheet destination cell insert =SUM(

then select the JAN sheet tab, hold shift and select december sheet tab
- this will select all the sheets, select the cell that has the month's
total.

Close off the brackets and hit enter.

This will sum all the cels from the 12 sheets.

HTH

Ed--
EdMac
------------------------------------------------------------------------
EdMac's Profile: www.excelforum.com/member.php...oamp;userid=30736
View this thread: www.excelforum.com/showthread...hreadid=528308
Sean

Sorry for delay in reply but your suggestion worked in with a contacts
list I had. Many thanks for your assistance.
stm
Sean Wrote:
gt; Hi,
gt;
gt; You may need to create a helper column in each on the monthly
gt; spreadsheets
gt; with one cell that contains both the first name and surname. Then in
gt; your
gt; summary sheet you could do a vlookup and get the monthly score for
gt; each
gt; player for each month.
gt;
gt; Hope this helps.
gt;
gt; Sean
gt;
gt; quot;sonic-the-mousequot;
gt; wrote
gt; in message ...
gt;
gt; I have set up a spreadsheet for a local squash league.
gt;
gt; There are 12 worksheets, 1 for each month of the year, named
gt; accordingly.
gt; In Column A is the players first name, Column B their surname and in
gt; Colum K their score for the month. (In between is game scores)
gt;
gt; What I am trying to do is set up a running total for all competitors
gt; so
gt; that at the end of the year I will have everyones monthly score and
gt; total score over the year.
gt;
gt; I have listed the player names (first and surname) in column A of
gt; another worksheet, totalscores!, which has columns for each month.
gt;
gt; I was wondering what formulae to use to search through the worksheets
gt; to find the player in the monthly worksheet and return their score at
gt; the end of the month.
gt;
gt; Any help appreciated in advance.
gt;
gt; stm
gt;
gt;
gt; --
gt; sonic-the-mouse--
sonic-the-mouse