Excel 2007 : Autofilling formulas down

[KMRyan7926]

Ok, i don't know if there is a way around manually editing each cell for fix the problem.

I have a series of formulas set up in one spreadsheet for PBA bowling patterns and scores. one of the specific functions is for the max scratch score on a given pattern:

Ex: =IF(C4="Shark",MAX(D4:G4)," ")

When i copy this formula downward, the pattern does as follows:

=IF(C5="Shark",MAX(D5:G5)," ")
=IF(C6="Shark",MAX(D6:G6)," ")
=IF(C7="Shark",MAX(D7:G7)," ")
Etc.

which is exactly want i want, except for one thing: i want the first cell reference in the max function to remain as D4, instead of changing like the other two cell references:

=IF(C5="Shark",MAX(D4:G5)," ")
=IF(C6="Shark",MAX(D4:G6)," ")
=IF(C7="Shark",MAX(D4:G7)," ")

Is there any way for the auto fill downward to do this, or do i have to manually edit each number back to 4 to match what i want the formula to do?

Thanks for your help.

[davesexcel]

Try
=IF(C5="Shark",MAX($D$4:G5)," ")

[KMRyan7926]

Excellent! thanks much!


that seems so simple too, but i didn't know what the $ did in excel.