Get index column, when sum of column values reaches a goal

[edavilac]

Hello Team, I appreciate your help

Please see attached file.

I have different columns (one for each week), and I need to determine when that sum of column values reaches or surpasses a goal (in this example, the value is fixed, 10).

In the attached file, I included the expected output, I need to get the index of the column, when the goal is achieved (even if it is surpassed), this for each row.

Thanks in advance for your help.

 

[bosco_yip]

In J3 formula copied down :

=IFERROR(INDEX(A$2:G$2,AGGREGATE(15,6,A$2:G$2/((SUMIF(OFFSET(A3,,,,A$2:G$2),"<>")+1)>=H3),1)),"N/A")

Or, this shorter formula, will get the same results

=IFERROR(AGGREGATE(15,6,A$2:G$2/((SUMIF(OFFSET(A3,,,,A$2:G$2),"<>")+1)>=H3),1),"N/A")

 

[edavilac]

In J3 formula copied down :

=IFERROR(INDEX(A$2:G$2,AGGREGATE(15,6,A$2:G$2/((SUMIF(OFFSET(A3,,,,A$2:G$2),"<>")+1)>=H3),1)),"N/A")

View attachment 73677

This is sooo good!

Thank you, Bosco, you rock!