I have a spreadsheet that has filters breaking down different departments. Example department A, B, C. The line items are representing projects with cost associated to each department. I would like to be able to total based on an applied filter. For example if a user selects department B I would like them to see the total amount for just department B, when the filter is changed to department C I would like the sum to updated, etc. I would also like it to show the total for all 3 departments if there are no filters.
I'm using Excel 2003, is this possible.
I'm using Excel 2003, is this possible.
