| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying formulas without changing the range
I use a lot of Countif formulas. When I copy the formula from one worksheet
to another, or from one row to another, it changes the range (i.e. J6:J69 becomes J7:J70, etc.) I want to maintain the same range (J6:J69) but cannot get it to do that. Does anyone know how I can keep the range the same in subsequent rows? I just want to change the criteria of the count, not the range. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying formulas and changing cell references | Excel Discussion (Misc queries) | |||
| copying formulas but changing the column # | Excel Discussion (Misc queries) | |||
| COPYING OFFSET FORMULA WITHOUT THE DATA RANGE CHANGING-DESPERATE | Excel Worksheet Functions | |||
| Copying a named range with a changing cell reference | New Users to Excel | |||
| Copying formulas without changing previous results/calculations | Excel Worksheet Functions | |||
Threaded Mode
