Filter Totals

ExcelRoy

Well-known Member
Joined
Oct 2, 2006
Messages
2,436
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
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

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
 

Watch MrExcel Video

Forum statistics

Threads
1,114,381
Messages
5,547,613
Members
410,803
Latest member
lsweeney
Top