3 1 solution High Priority ? 55 Views 1 Endorsement Last Modified: 2018-09-06
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 a certain number in a cell. looking for the first time an array crosses that mark
note- an array is between columns H-CA
once it hits that sum threshold, NOWi need to sum the NEXt twelve columns of data.