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

Hi there,


Prob1; (tab1 spreadsheet)
Trying to make a spreadsheet to keep track of financial numbers in different businesses.

Put an example chart here. Trying to make this formula so that when you come into 2019 and enter income day by day the formula will update when the 1st million is made, 2nd etc.

Prob2; (tab2 spreadsheet)
And i also have a problem with circleref. in a % formula i made that also should come into action as the year goes.

Any help would be much appreciated!