Filter Totals

ExcelRoy

Well-known Member
Joined
Oct 2, 2006
Messages
2,465
Office Version
  1. 2007
Platform
  1. Windows
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
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
Why use a filter? The Pivot Table was designed for this type of app.

lenze
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,127
Messages
5,857,525
Members
431,883
Latest member
Hien

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top