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