I have a table containing all the sales I have made in a particular month. I have a 'sum' function to give me the total of the sales I have made in this month. However, I want to be able to use 'Autofilter' to filter on a particular product, then I want to be able to see the total for just that product. Then when i filter on a different product, i want it to display the total for that product instead.
is this possible?
thanks,
Bookmarks