gixxer,
Tried that, worked but it would not offset the line1 cell. it looped till
the active cell was = to "Condiments" but only added the value of "L2" to
the subtot instead of offsetting it to the row below every loop.

Ashley