Home |
Search |
Today's Posts |
#1
|
|||
|
|||
filter sum
I have a cost sheet with lots of products in from different manufacturers.
I then created a worksheet for an order to these manufacturers, using the autofilter to select which manufacturer I would like. However when I insert a total at the bottom of the order and use the 'sum' formulae it totals up the costs for every manufacturer not just the ones i filtered. What can I do? |
#2
|
|||
|
|||
Use the SUBTOTAL worksheet function when you want to sum,
count, average, etc. data that has had a filter applied to it. The XL help file is pretty straightforward on its use. HTH Jason Atlanta, GA -----Original Message----- I have a cost sheet with lots of products in from different manufacturers. I then created a worksheet for an order to these manufacturers, using the autofilter to select which manufacturer I would like. However when I insert a total at the bottom of the order and use the 'sum' formulae it totals up the costs for every manufacturer not just the ones i filtered. What can I do? . |
#3
|
|||
|
|||
Take a look at =subfilter() in Excel's help.
Or visit Debra Dalgleish's site: http://www.contextures.com/xlFunctions01.html#Filter Jonny wrote: I have a cost sheet with lots of products in from different manufacturers. I then created a worksheet for an order to these manufacturers, using the autofilter to select which manufacturer I would like. However when I insert a total at the bottom of the order and use the 'sum' formulae it totals up the costs for every manufacturer not just the ones i filtered. What can I do? -- Dave Peterson |
#4
|
|||
|
|||
Subfilter? Go pour yourself another cup of coffee, Dave
<g. Jason -----Original Message----- Take a look at =subfilter() in Excel's help. Or visit Debra Dalgleish's site: http://www.contextures.com/xlFunctions01.html#Filter Jonny wrote: I have a cost sheet with lots of products in from different manufacturers. I then created a worksheet for an order to these manufacturers, using the autofilter to select which manufacturer I would like. However when I insert a total at the bottom of the order and use the 'sum' formulae it totals up the costs for every manufacturer not just the ones i filtered. What can I do? -- Dave Peterson . |
#5
|
|||
|
|||
Can I blame autocorrect?
Or the keyboard or the weather??? Jason Morin wrote: Subfilter? Go pour yourself another cup of coffee, Dave <g. Jason -----Original Message----- Take a look at =subfilter() in Excel's help. Or visit Debra Dalgleish's site: http://www.contextures.com/xlFunctions01.html#Filter Jonny wrote: I have a cost sheet with lots of products in from different manufacturers. I then created a worksheet for an order to these manufacturers, using the autofilter to select which manufacturer I would like. However when I insert a total at the bottom of the order and use the 'sum' formulae it totals up the costs for every manufacturer not just the ones i filtered. What can I do? -- Dave Peterson . -- Dave Peterson |
#6
|
|||
|
|||
Cheers lads |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
Pivot table and filter | New Users to Excel | |||
Advanced Filter: No Filter | Excel Discussion (Misc queries) | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |