| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I stop Excel from progressing a formula in fill down or rig
I am trying to use a sumif command and want excel to copy the formula in each
cell EXACTALY like it is. Excel keeps "progressing" the formula. I just want the exact formula repeated over and over. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I stop Excel from progressing a formula in fill down or rig
Use absolute references, not relative references. I.e, =SUM($A$1:$A$1000),
not =SUM(A1:A1000) Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "mbaysden" wrote: I am trying to use a sumif command and want excel to copy the formula in each cell EXACTALY like it is. Excel keeps "progressing" the formula. I just want the exact formula repeated over and over. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I stop Excel from progressing a formula in fill down or
TY I knew it was a very easy solution. Thax again
"Dave F" wrote: Use absolute references, not relative references. I.e, =SUM($A$1:$A$1000), not =SUM(A1:A1000) Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "mbaysden" wrote: I am trying to use a sumif command and want excel to copy the formula in each cell EXACTALY like it is. Excel keeps "progressing" the formula. I just want the exact formula repeated over and over. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| in Save As,how to stop auto fill in whatever the mouse hovers on? | Setting up and Configuration of Excel | |||
| How do I stop excel from auto formula, ie 48E69 makes 48.0e+70? | Excel Worksheet Functions | |||
| Fill down not progressing | Excel Discussion (Misc queries) | |||
| sum multiple rows based on progressing date field on each row | Excel Worksheet Functions | |||
| stop auto fill from thinking for itself!!!!!!! | New Users to Excel | |||
Linear Mode
