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? |
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) |