Make some type of indicator in the next column. So for example next to the drinks you would enter A and next to the others you would enter B. Then after the subtotal use a sumif to add the A items and multiply that by 20%, then sumif the B items and multiply by 5%.

thanks

this is the formula i wrote

=SUMIF(I5:I34,4,D5:D34*x.2)

it works without the *x.2, but then it gives me the

**total** of the 'foods'.

with the *x.2 I get an error message

how can get it to calculate only 20%