finnstone
asked on
vba code almost working, just needs one edit to look at one column to left of where it looks
need a code script modified.
you will see in the attached that the formula is summing the wrong columns. it is supposed to look for when the array crosses 215,000 of the sum of the preceding columns, then take the sum of all of the next columns . for some reason it starts an n+1, n+2 instead of summing n,n+1,n+2...i.e. it skips the cell immediately following the cell where threshold was crossed.
RunningSumTestingQ29115305-SUMMING-.xlsm
you will see in the attached that the formula is summing the wrong columns. it is supposed to look for when the array crosses 215,000 of the sum of the preceding columns, then take the sum of all of the next columns . for some reason it starts an n+1, n+2 instead of summing n,n+1,n+2...i.e. it skips the cell immediately following the cell where threshold was crossed.
RunningSumTestingQ29115305-SUMMING-.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window
The only difference between these two formulas is value of last parameter.