In column L, I want to create a function where if the cell next to it in column K is >0, then it is 0, but if it is =0, then it adds all the cells going up to the next cell which =0 So since K10 and K4 =0, L10 is the sum of K5:K9. But then once it finds the next cell=0 I don't want it does to look further.
A string of IF statements only goes so far (I think 6 nested statements). Any thoughts?
A string of IF statements only goes so far (I think 6 nested statements). Any thoughts?