Need help with formula

[jsallmann]

Hello Group,

I am terrible at excel formulas and functions. I am trying to create
one for the below chart;

Total Points Season
2003 2004 2005 Lifetime
Team Points Team Points Team Points
Browneye 762 Skips 705 Browneye 1332
SkipStudz 597 Browneye 2 679
Godfather 2 556 Phurst Skirt 668
N. Yorker 532 Hackett Kid 571
Godfather 529 Browneye 570
Phurst Skirt 527 Godfather 2 561
Skips 501 Godfather 558
Big Daddy 484 Big Daddy 548
BDAU 494
Big Shank 451

To the right is a lifetime column. What I would like to do is to sort
the stats in the lifetime column by team name and the total points
where the first entry in the list is top points. Meaning I need a
formula that will add the points for the years 2003, 2004 and 2005 and
add them into the lifetime column but automatically correlate them with
the proper team name.m The first entry under lifetime Points should be
most points. I created an example for you.

Any help would be appreciated.

Thanks,

Joe

 

[Dave Peterson]

How about an alternative.

Instead of using the columns (going right to left) to store your stats, use
rows.

Put the year in column A.
Put the team name in column B.
Put the points for that year in column C.

Then you could use Data|pivottable to get that summary.

And if you use a dynamic range name that will grow when you add more stats, all
you'll have to do is refresh the pivottable to get the lifetime points.

If you like this idea, you can read more about dynamic ranges at Debra
Dalgleish's site:
http://www.contextures.com/xlNames01.html#Dynamic

To read more about the pivottable stuff, you may want to look at some links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx

 

[jsallmann]

Thanks Dave,

I'll look into this. I appreciate the suggestion.

 

[jsallmann]

Works Perfectly,

Thanks for the info and links