Filter then Re-Calculate for only the Filtered Results

[sebexcel]

Tech savvy, but an Excel newbie here. I've been trying to find the answer to this question with no success.

Background: I have 2 sales employees. Let's call them Mike and Jessica. My spreadsheet has records of each one of their completed sales, with the final column automatically calculating (by addition) TOTAL SALES TO DATE between the two.

When using the Filter to single out only Mike's numbers, I would like for the filtered results to show ONLY HIS sales numbers calculated in the same manner as when whole spreadsheet shows both Mike and Jessica's combined sales numbers.

In other words, when I single out Mike using the FILTER option, it still shows the combined sales numbers for both Mike and Jessica in the TOTAL SALES TO DATE column. I would like for it to only show Mike's calculated numbers in that column.

Any help with this would be greatly appreciated.

Seb

[Pete_UK]

Post the formula that you are using in the TOTAL SALES TO DATE column.

Pete