I have 1,2,3,4,5,0 for cell A1, B1, C1, D1, E1, and F1 respectively. I want a function that would give me result of for example D2 with 25% and E2 with 50%. This means that when the next number is zero, the function would provide a result for the last two cells with numbers (other than zero) prior to that zero. Please see attached picture.