+ Reply to Thread
Results 1 to 4 of 4

Formula is only repeating, not continuing

  1. 07-12-2019, 01:57 AM #1
    kater101
    kater101 is offline
    Registered User
    Join Date
    07-12-2019
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    2

    Formula is only repeating, not continuing

    I was wondering if anyone would be able to help me!
    My formula when I drag it down repeats instead of continues, ie. goes back to one instead of sequentially continuing. This is it:
    =COUNTIFS('P-01'!$D:$D, "Insertion", 'P-01'!$E:$E, "Surface",'P-01'!$F:$F, "Y")
    =COUNTIFS('P-02'!$D:$D, "Insertion", 'P-02'!$E:$E, "Surface",'P-02'!$F:$F, "Y")
    =COUNTIFS('P-03'!$D:$D, "Insertion", 'P-03'!$E:$E, "Surface",'P-03'!$F:$F, "Y")
    =COUNTIFS('P-04'!$D:$D, "Insertion", 'P-04'!$E:$E, "Surface",'P-04'!$F:$F, "Y")
    =COUNTIFS('P-05'!$D:$D, "Insertion", 'P-05'!$E:$E, "Surface",'P-05'!$F:$F, "Y")
    etc.
    I have gotten to 25, but it still repeats. I have tried pressing F9 / manual calculation but it doesn't seem to work.
    Does anyone know how to make Excel recognise the pattern?
    Thanks!
    Reply With QuoteRegister To Reply
  2. 07-12-2019, 02:19 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,240

    Re: Formula is only repeating, not continuing

    Welcome to the forum.

    Your sheet names will not increment automatically. You will need to use the INDIRECT function.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 07-12-2019, 10:14 AM #3
    kater101
    kater101 is offline
    Registered User
    Join Date
    07-12-2019
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    2

    Re: Formula is only repeating, not continuing

    Thanks for your prompt reply!
    Could you guide me as to how to use that?
    Reply With QuoteRegister To Reply
  4. 07-12-2019, 10:57 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,047

    Re: Formula is only repeating, not continuing

    See if you can adapt this your your formula...
    INDIRECT("'P-"&TEXT(ROW(A1),"00")&"'!D:D")

    This would replace the current sheet/cell references
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] continue formula down column after inserting rows or continuing at the bottom
    By jitterbug888 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-14-2019, 10:02 PM
  2. how to add row continuing the formula
    By sharadmaxwell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-14-2016, 07:48 AM
  3. Continuing Formula
    By thyzt in forum Excel General
    Replies: 1
    Last Post: 06-09-2016, 12:38 PM
  4. How to complete a large formula by continuing a pattern
    By Crystal Barker in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-15-2016, 05:58 PM
  5. Problem Continuing Formula When Copy and Pasting
    By voz45 in forum Excel General
    Replies: 3
    Last Post: 05-29-2014, 04:14 AM
  6. creating a repeating formula that doesn't show repeating values
    By cybershot in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-09-2010, 06:12 PM
  7. continuing formula when cells are empty
    By Cyrus in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-17-2006, 11:59 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1