Filter Totals

[ExcelRoy]

hello,

could you please help me with the following

using the filter, how can i have a total value for certain lists using the filter

i.e. i have entered 20 lines

cell A is part number
cell B is description
cell C is price
cell D is job number

i would like to sort all for a certain job with a total price on that job

thanks

 

[lenze]

Why use a filter? The Pivot Table was designed for this type of app.

lenze

 

[Richard Schollar]

Hi Roy

While Lenze is undoubtedly correct, you can get the total from your filtered list using the Subtotal function:

=SUBTOTAL(9,C2:C1000)

adjust the range so that it encompasses all the rows of your entire data area (ie not just the filter rows), and the 9 part of the subtotal ensures that only visible rows (ie the filtered values) are summed.

Best regards

Richard