Need to filter a spreadsheet at the SUBTOTAL level.

  • Thread starter Thread starter UNCLE WALT
  • Start date Start date
U

UNCLE WALT

In Excel, I am trying to figure out how to filter all rows
that fail to meet a specific criteria at the SUBTOTAL
level. For example I have multiple rows in my spreadsheet
for each vendor, one for each dept. I would like to
filter out all rows for a vendor if the total sales units
for all departments combined for that vendor is less than
a certain number. I know this must be possible but so far
neither my books nor my own researches have yielded the
correct method. Help would be greatly appreciated.
 
Uncle Walt,

You can certainly do it with a helper column and a pivot table. Use a SumIf comparative formula in the helper column, along the
lines of

=Sumif(A:A,A2,C:C)>1000000

Copied down to match, where A has vendor names, and C has amounts. In your pivot talbe, only show those Vendors where the helper is
TRUE - in this case, where total sales are greater than 1000000.

HTH,
Bernie
Excel MVP
 
Bernie, Thank your for your help.
-----Original Message-----
Uncle Walt,

You can certainly do it with a helper column and a pivot
Click to expand...
table. Use a SumIf comparative formula in the helper
column, along the
lines of

=Sumif(A:A,A2,C:C)>1000000

Copied down to match, where A has vendor names, and C has
Click to expand...
amounts. In your pivot talbe, only show those Vendors
where the helper is
 
Back
Top