subtotals, percentage charts, multiple sheets

[rini247bini]

Hi! I need some help - i've attached what i need to work with.
It's a hypothetical scenario, basically this is Sheet1. I know how to make a grand total.

In another sheet I need to show all the YES's
- and a percentage (from the dollar subtotal to the grand total)

-and then another percentage showing the NO WARRANTY's and WARRANTY's in relation to the YES's (I hope that makes sense).


In another sheet I need to show all the NO's- and a percentage (from the dollar subtotal to the grand total)

a chart would be helpful too.


thank you in advance!!!





$150 YES WARRANTY
$120 YES WARRANTY
$70 NO
$90 NO
$200 YES NO WARRANTY
$500 YES WARRANTY
$900 YES WARRANTY
$80 YES WARRANTY
$55 NO
$80 NO