sumif
 

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?

sumif
 

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?

sumif
 

In case you have not found XL Help, you will need to do this:

=sumif('AGP INV 1'!E$11:E$45, "Beyond", 'AGP INV 1'!G$11:G$45)

Note that you need two apostophes around sheet names which contain
spaces.

Hope this helps.

Pete

On Jan 13, 10:56*pm, 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?