I have a spreadsheet and I don't want to have all the info on the bottom.

Ex of my spread. I want the regions of diff regions ex Northeast to say
its subtotal without all that info when u go to data and subtotal. I do a
filter on the regions column and i want the subtotal to reflect in the totals
column ex the regions fornortheast to say $32.00 in the total column because
when do the subtotal for northeast is $32.00. Without the list of Northeast
etc It should be only be shown the subtotals in the total.

Regions Extended Pricing Total
$103.00

Northeast $12.00
Southeast $44.00
Northeast $10.00
Southest $32.00
Midwest $5.00