need a formula to find the column where an array crosses a certain threshold
so need to find the column number where that happens
threshold is 19,000 , looking for the first time an array crosses that mark
note- an array is between columns H-CA
then i need to sum the NEXt twelve columns of data.
so for example, if COL M has 17,500 AND col N has 19,400, and this was first time we crossed 19,000 (ie it didnt happen in colmns A-L, then i need to sum columns O-Z
need to do this across rows 7-480