Learn Excel Episode 143: Mixed References
Sometimes you need a formula to always point to a particular row but allow the column to change. Or, you might need it to point to a particular column but allow the row to change. This is called Mixed References. Episode 143 will show you both varieties.