Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

MS Excel 2007 - Sum $ amount for my filtered selection.

How do I add a cell to sum up the value that I select in a filter?

I have a list locations and $ amounts. Each location has its own dollar amount. The column headers for this data has the drop down filter turned on.  I want to add to my spread sheet a cell that sums the dollar values for the location that I select in from my filter.  If I select from my filter Albany I want the summary cell to only total Albany $ amounts. If I change to a new location the sum should change accordingly.

SUM: $926,000

Location      Amount            
Albany      $340,000
Albany      $123,000
Rensselaer  $456,234
Rensselaer $156,000
Saratoga      $340,000
Saratoga      $123,000
Albany      $340,000
Albany      $123,000
Rensselaer $456,234
Rensselaer $156,000

I know I can do this with a Piviot table  or insort subtotals into the data. My question is specific to summing data for a selected filter.

Thanks for your assistance
Ldufresne
0
Lou Dufresne
Asked:
Lou Dufresne
1 Solution
 
NorieData ProcessorCommented:
Try SUBTOTAL.

=SUBTOTAL(9,B3:B12)

Where B3:B12 is the range with the dollar amounts.
0
 
Lou DufresneIT Business Analyst CSM / Project ManagerAuthor Commented:
Can you please tell me what the "9" is in the formula  =Subtotal(9,B3:B12)

Other than that the fornula works great.

Thanks
Ldufresne
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now