Count columns and rows until value reached -> continue counting til next value reached

Hi,

I dont really have any excel background, so what i get from what you are saying is more or less; I don't setup my excel spreadsheets the right way for formulas etc. to work properly.

If you could take a look i can send the main sheet for you to take a look at and give me feedback on the setup. (Which i think might be incorrect to make use of functions).

Hi again,

Filling in some context, if you havn't seen scheme 1. (I would strongly suggest to take a glance at it before picking up example sheet 2)

The formula im missing is mainly a summary of equal the one i request in example scheet on tab 1, if this is not possible to make with the collumn/rows setup the way i have in Example sheet 2 here (larger area of nr's vs example sheet) how can it be done to make a formula that counts and tells the amount of days spent to accumulate 1 million in income automatically?

The 2nd problem is that the formula shown on example sheet on tab 2 goes to circle ref. But when it gets numbers during 2019 it will automatically transform into a % in a positive or negative value. (Does it even matter??) Or should i just put false part of =if equation to a static cell with text "TBC" ?


Like said before, any help will be greatly appreciated, been banging my head against Youtube tutorials the last couple of days to try and figure out a formula or any other way to accumulate this formula up ahead of the numbers actually appearing under 2019.

The point of this formula is to be able to compare how many days you use to generate 1 million in income compared to other years, as in 2017 maybe it's 30 days vs 2018 you use 40 days etc. To keep track off key points in total income.