In an effort to learn excel better, I thought I'd apply my studies to
various hobbies I undertake.

Current hobby: Fantasy Basketball. (btw, I wish all a good round of
betting, etc)

I've decided to create a player value based on current statistics
multiplied by a multiple that is based on the average of statistics
over the past 10 years.

For example, I've decided that points are rather common and the
multiple for points would be 1. Steals on the otherhand are much more
rare and float between 10-13 times less than the ability to score 2
points. This 10-13 is my 'multiple". I take all the current stats and
then multiply then to the various multiples in the categories.

I.e.

I have data in cells row F3 through I3
I wish to multiple each of these cells to a "multiple" as described
above on another sheet in cells A2 through D2 respectively. (F3 to A2,
G3 to B2, etc)

This works out fine.

Then I have data in cells row F4 through I4.
When I take the formula, the the excel takes my formula and chances
F3-I3 to F4 and I4, but changes A2 through D2 to A3 through D3. (F4 to
A3, G4 to B3)

I would like the row to change for my data, but the multiple reference
in the formula to remain.

Can anyone help this new kid on excel?

Thanks.