Subtotals but without all the info. PLEASE HELP!

[Guest]

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

 

[Don Guillett]

I think SUMPRODUCT should be of help
=sumproduct((a2:a22="Northeast")*b2:b22)
or
=sumproduct((a2:a22=c2)*b2:b22)

 

[Guest]

hi Don,

Thanks for responding to my ques.
I found my answer the answer is =SUBTOTAL(9,AP2:AP88)

 

[Guest]

Hi Don,

Thanks for responding to my ques.

I found my answer.

=SUBTOTAL(9,AP2:AP88)

Cynthia