Need to filter a spreadsheet at the SUBTOTAL level.

[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.

 

[Bernie Deitrick]

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

 

[uncle walt]

Bernie, Thank your for your help.

-----Original Message-----
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