Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Sumif | Excel Discussion (Misc queries) | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |