Calculating list data based on multiple criteria

Hi all,

I have a list of purchases made by an individual and want to see if their first purchase was a "coupon purchase" followed by a "noncoupon purchase" at anytime thereafter. Ideally (but less important), I would like to calculate the total value of purchases made after the initial purchase for those determined above.

I have attached and excel sheet where I am trying to find formulas to calculate the green cells explained above.

Thanks for any possible help or ideas!