| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIf - when I fill down the Range, Criteria & sum range changes
I would like to fill down & keep the same range & sum range - but let the
criterial advance by 1 - field in the next file. Is this possible? Also, will excel keep the info (function) straight as I sort the file? Thanks much |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SumIf - when I fill down the Range, Criteria & sum range changes
Add a $ to Col Letter and/or Row Number if you do NOT want it to change...
All other references (which are without a $ will change) -------------- =$A$1 change neither row nor column =A1 change both row and column =$A1 change row but not column =A$1 change column but not row "markholt" wrote: I would like to fill down & keep the same range & sum range - but let the criterial advance by 1 - field in the next file. Is this possible? Also, will excel keep the info (function) straight as I sort the file? Thanks much |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SumIf - when I fill down the Range, Criteria & sum range changes
THANK YOU - I've been struggling wth this - now the doller is STRONG !!!
markholt" wrote: I would like to fill down & keep the same range & sum range - but let the criterial advance by 1 - field in the next file. Is this possible? Also, will excel keep the info (function) straight as I sort the file? Thanks much |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SumIf - when I fill down the Range, Criteria & sum range chang
:-)
Very well said! "markholt" wrote: THANK YOU - I've been struggling wth this - now the doller is STRONG !!! markholt" wrote: I would like to fill down & keep the same range & sum range - but let the criterial advance by 1 - field in the next file. Is this possible? Also, will excel keep the info (function) straight as I sort the file? Thanks much |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif when criteria is a range | Excel Discussion (Misc queries) | |||
| SUMIF with AND for range and criteria | Excel Worksheet Functions | |||
| SUMIF using two columns in both Range and Criteria | Excel Discussion (Misc queries) | |||
| SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
| SUMIF multiple criteria in 1 range | Excel Worksheet Functions | |||
Linear Mode
