| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Formula Down Without Changing Entire Formula
It's called absolute addressing (refer help)
Just use $ sign in front of row, column or both to keep it fixed eg. $D8:$D1000 Fixed Column D$8:D$1000 Fixed Rows $D$8:$D$1000 Fixed Row & Columns George roy.okinawa wrote: I have this formula: =COUNTIF(Overall!D8:D1000,A15) I want to copy it down but do not want the D8:D1000 to change. That is the range that is being looked at on the other worhsheet. The only thing that should change is the A15. It will change to A16, A17, etc. as it is copied down. Help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Formula That References Another Sheet | Excel Discussion (Misc queries) | |||
| 2 Nesting questions | Excel Worksheet Functions | |||
| How do I copy a formula with relative ref. keeping the same ref.? | Excel Discussion (Misc queries) | |||
| Copy a formula down a set number of times | Excel Worksheet Functions | |||
| need a formula to copy entire row to next worksheet | Excel Worksheet Functions | |||
Threaded Mode
