Posted to microsoft.public.excel.misc

roy.okinawa

Posts: n/a

Copy Formula Down Without Changing Entire Formula

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy Formula That References Another Sheet	JR573PUTT	Excel Discussion (Misc queries)	9	February 16th 06 10:24 PM
2 Nesting questions	Starchaser	Excel Worksheet Functions	7	January 20th 06 06:53 PM
How do I copy a formula with relative ref. keeping the same ref.?	avjunior	Excel Discussion (Misc queries)	4	October 12th 05 02:54 AM
Copy a formula down a set number of times	Julian	Excel Worksheet Functions	1	September 23rd 05 06:43 PM
need a formula to copy entire row to next worksheet	aledger	Excel Worksheet Functions	5	March 8th 05 12:45 AM

All times are GMT +1. The time now is 10:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us