Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Original subtotals should not be within nested subtotals in excel | Excel Worksheet Functions | |||
Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions |