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
Bookmarks