I have had a quick look at the worksheet with the little modification, however, it still does not match the desired results as displayed in the lower half of the worksheet "Desired Results" (rows 19 through 31).

This should also answer your first question I believe.