In my Google Sheet (see my example sheet here), I have 2 tabs, a Main tab which lists names in A3:A, and a Data Tab in which the names appear somewhere in B1:1, and three columns of data under each name, named SPEND, INCOME, and MISC. A3:A contains Dates in ascending order.

The SPEND columns contain random amounts spent on certain days for each name. The INCOME columns contain random income amounts received on certain days for each name. The MISC columns are for other unrelated data.

On Main Tab, I am trying to figure out how to write a single arrayformula for cell B2 that will calculate the average number of days it takes for each name listed in A2:A to reach their amount spent with their received income.

The only applicable spends for each name are the ones that appear after the first row in which their income is greater than 0, and if the last spend amount has not yet been reached by the income, it is not included in the average either.

The closest I was able to get to this solution was this formula in E3 dragged down to get the average number of days for a specific name (see the Testing Tab in my example): =IF(B3<>"",MATCH(TRUE,INDEX(SUMIF(ROW(C3:C28),"<="&ROW(C3:C28),C3:C28)>=B3,0),0),"") but it isn’t starting at the correct row and I am unsure of how to put this into an arrayformula.

What is the best way to accomplish what I am looking for?