See the "The difference between relative and absolute references" topic
in XL Help.



In article ,
SPolansky wrote:

my formula is =sumif('AGP INV 1! E11:E45, "Beyond", 'AGP INV 1! G11:G45).
The formula is working great but when I use the drop and drag tool to put
this in multiple cells it makes the E11 and E45 advance by one number. I
always want it to select from E11:E45. What do I need to do to make that
selection permnate?