sumif

[SPolansky]

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?

 

[JE McGimpsey]

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

 

[Pete_UK]

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