Hello.
I am trying to add a filtered column (changing the filter by salesman) and have the summed total just add the chosen salesman.
The sum at the bottom is the total for all the salesman. Trying to get just the one that chosen for the current filter. I have attached the sheet and what I am trying to do is if I sort by salesman or location have the total which is the third column show the total by the chosen sort.
Thanks in advance for your help.
Bookmarks