Sorting Multiple Years of Data

[Mark]

Each year my sports team do seven different items that we test them. (#1, #2,
#3, #4, #5, #6 and #7). The students get a certain amount of points depending
on how they did in each category. We have an excel spreadsheet that have each
category on a seperate sheet and a Main sheet that displays every categories
and the points scored. It displays the players name, grade points scored, etc.

What is the best way to consolidate every year into one area. I would like
to be able to sort by year, by player (all years), by points, by grade, etc.
I would like it to automatically update. Which office program is the best to
do this? Any suggestions?

 

[Renee]

You can insert a new worksheet into your workbook, click the cell where you
want the data to be included, then begin your formula (=sum(...)), then go to
the worksheets with the data and start clicking the cells you want to add or
subtract in each worksheet. Be sure to write your formulas like you would if
you were doing it in any worksheet.

For instance (please note that messages in brackets [] are purely
instructional and not to be misunderstood as part of the formula):

=sum([click worksheet #1, cell A1]+[click worksheet #2, cell A1]+[click
worksheet #3, cell A1])

This will give you a total of what’s in cell A1 on all three worksheets. If
you’re a good formula writer, you can figure out the rest.