Fantasy Football and Excel Functions (need lotsa help)

[putzkoff]

I want to figure out how many fantasy points football players scored
last year. I have a sheet with their names and some stats that are
sorted by columns. For example:

Holmes, Priest 0 0 0 0 1615 21 70 672 3 0 0 1
Alexander, Shaun 0 0 0 0 1175 16 59 460 2 0 0 1
Williams, Ricky 0 0 0 0 1853 16 47 363 1 0 0 5
Portis, Clinton 0 0 0 0 1508 15 33 364 2 0 0 3
Faulk, Marshall 0 0 0 0 953 8 80 537 2 0 0 3


Each of these stats are worth a certain number of points. I have a
function that totals up the players points, but it has a static row
number. For example:

= C3 + D3/25 + E3*6 - F3 *2 + G3/10 +H3 *6 + F3 +I3/10 +J3*6 +K3*6
+L3*2 - M3 *3

Columns A-D don't really apply to these specific players, but other
guys have stats that I need calculated. What I need is instead of
manually typing C3, D3, etc, to somehow dynamically insert the row
number, like C($row). Is this possible? It must be. Any help is greatly
appreciated. Thanks!



------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
at http://www.ExcelTip.com/
------------------------------------------------

 

[Max]

oops, there's a typo in the bracketed line below
(col M should read col N):

..... double-click at the black cross in O3
(This will copy down the formula until the last non-blank cell in col M)

 

[Max]

so, guess my 2 cents try didn't really address what you're after.
perhaps if you gave some feedback, others might be able
to step-in with better ideas for you?

 

[Max]

you're welcome.. cheers.