Results 1 to 14 of 14

Stop countif with circular reference

Threaded View

  1. #1
    Registered User
    Join Date
    07-27-2016
    Location
    manchester
    MS-Off Ver
    Office 365
    Posts
    12

    Stop countif with circular reference

    Hi,

    My problem is easier to understand with the excel open. What I want is to enter a certain number of stores to be opened in a given year and once that number has been reached to pass to the openings of the second year, that until the number of stores of the last year have been reached and then the result is blank. Unfortunately, since the the result is dependent of the COUNTIF() which itself is dependent of the result the formulas gives a circular reference. Is there any way to give the number of stores of the first year and then once that number has been reached to pass to the second part of the formula?

    Thank you in advance for your help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to stop the help popup window with circular references?
    By ericsastud in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-04-2019, 03:48 AM
  2. Replies: 2
    Last Post: 02-23-2014, 06:06 PM
  3. [SOLVED] how to stop circular reference warning?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-21-2013, 07:53 PM
  4. [SOLVED] Stop circular reference warning
    By shiftyspina in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-21-2013, 08:57 AM
  5. Circular Reference when formulas reference end of row formula!
    By Spellbound in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-29-2009, 08:26 AM
  6. Replies: 1
    Last Post: 08-21-2007, 07:22 PM
  7. Stop Circular Reference Help Notices
    By Brig Siton in forum Excel General
    Replies: 2
    Last Post: 05-19-2006, 01:10 PM

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