sumif

  • Thread starter Thread starter SPolansky
  • Start date Start date
S

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?
 
See the "The difference between relative and absolute references" topic
in XL Help.
 
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
 
Back
Top