+ Reply to Thread
Results 1 to 3 of 3

Copy formula exactly while counting up the reference number

  1. #1
    Registered User
    Join Date
    12-29-2016
    Location
    Texas
    MS-Off Ver
    Excel:MAC
    Posts
    3

    Question Copy formula exactly while counting up the reference number

    Good Evening and Thank you in advance for any help.

    I am trying to copy a formula in 1000 rows, without it changing, yet keeping the reference number the same.

    ex.
    =COUNTIF(MON!C10:C70,KEY!E3)
    * *=C10:C70 NEEDS TO REMAIN THE SAME
    while E3 counts up E4, E5, E6 etc, to E1000

    =COUNTIF(MON!C10:C70,KEY!E4)
    =COUNTIF(MON!C10:C70,KEY!E5)
    =COUNTIF(MON!C10:C70,KEY!E6)
    =COUNTIF(MON!C10:C70,KEY!E7)

    When I copy and paste from he first cell it ends up counting the formula also.

    =COUNTIF(MON!C11:C71,KEY!E4)
    =COUNTIF(MON!C12:C72,KEY!E5)
    =COUNTIF(MON!C13:C73,KEY!E6)
    etc etc

    HOW do I keep the formula from changing while having the reference number count up??

    Thank you for any help!

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: Copy formula exactly while counting up the reference number

    Simply change to
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    12-28-2016
    Location
    London, England
    MS-Off Ver
    Office 2016
    Posts
    4

    Re: Copy formula exactly while counting up the reference number

    Hi,
    You can use absolute reference to create the formula to help you fix columns or rows you need.
    About how to use cell reference in Excel, you can refer to this article:
    http://www.excel-easy.com/functions/...eferences.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 03-02-2016, 10:41 AM
  2. [SOLVED] Copy Column A reference number values only for updated rows
    By SierraKilo78 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2014, 10:31 PM
  3. Replies: 0
    Last Post: 01-22-2013, 08:23 AM
  4. Replies: 1
    Last Post: 11-01-2012, 08:37 AM
  5. Counting number of times a cell reference appears in a 12 month period
    By Alistar3000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-23-2010, 04:52 PM
  6. Counting the number of non-empty cells beneath a reference cell
    By twills in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2009, 08:05 AM
  7. copy sheet by reference number
    By pichai in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-19-2008, 07:13 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1