On Sheet 1, I have a listing of stores. I have an auto filter on there so I
can filter by Account name and get back a listing of stores. I'm using the
the subtotal to get back a count of all the stores listed. On Sheet 2, I
have all the Account names and their total number of stores. I'd like to get
a % of stores retrieved using the subtotal. So if on Sheet 1, I filter on
ABC Stores and get back 6 and on Sheet 2 is shows that ABC Stores has 10
stores, how can I get the % (6/10 or 66%)? I'm assuming I can just do a
vlookup based upon the value of the Account name, but how do I tell the
formula to use the Account name that I filtered the table on?