I need a formula, please.

[Michelle]

I am working on a excel project that requires a ranking
system. What I'm tyring to figure out is... When I enter
new percents into a cell, I need the information to carry
over to another cell, and if it's possible carry over to
another workbook.

Here's the Idea..
August September Over all Ranking
Billy-100% Billy- Billy-
Dan-96% Dan- Dan-
Casey-38% Casey- Casey-

So now when the end of September information comes in, I
need to be able to put in the cell, and have it add to the
August information in the over all ranking area. Does
this make since? I fell like I'm rambling.
If anybody has any infromation on this, please help!
Thanks for your time!

 

[Frank Kabel]

Hi
not really sure what you're trying to achieve. You may provide some
more information

 

[RagDyer]

Probably the simplest way might be to add a column at the end of the list
that does the summing, and then reference that column in the Rank() formula.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I am working on a excel project that requires a ranking
system. What I'm tyring to figure out is... When I enter
new percents into a cell, I need the information to carry
over to another cell, and if it's possible carry over to
another workbook.

Here's the Idea..
August September Over all Ranking
Billy-100% Billy- Billy-
Dan-96% Dan- Dan-
Casey-38% Casey- Casey-

So now when the end of September information comes in, I
need to be able to put in the cell, and have it add to the
August information in the over all ranking area. Does
this make since? I fell like I'm rambling.
If anybody has any infromation on this, please help!
Thanks for your time!

 

[Steve Smallman]

Michelle,

This is a very basic use of Excel.

Structure your worksheet to see data, columns would be :
col A B C D.....
Z
1 Person August September etc
Overall
2 Billy 100%
3 Dan 96%
4 Casey 38%

So, you then add your data in each month's column.

now depending on what your overall ranking is, let's assume it is an average
in cell Z2 enter the formula =AVERAGE(B2:Y2), and this will average the
cells with data in them

Steve