Subtotals but without all the info. PLEASE HELP!
 

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

Subtotals but without all the info. PLEASE HELP!
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"CYNTHIA" wrote in message
...
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

Subtotals but without all the info. PLEASE HELP!
 

hi Don,

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

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"CYNTHIA" wrote in message
...
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

Subtotals but without all the info. PLEASE HELP!
 

Hi Don,

Thanks for responding to my ques.

I found my answer.

=SUBTOTAL(9,AP2:AP88)

Cynthia

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"CYNTHIA" wrote in message
...
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