Quick description of what I am trying to do- I have a list of salespeople,accounts, and revenue, a lot longer than what is shown below but trying to give you an idea.
Seller Account Revenue
Bob dfh 1,000
Bob dfhh 50,000
Bob ghd 25,000
Bob b 15,000
Joe ff 1,000
Joe rr 4,000
Joe sff 3,000
Joe gdg 5,000
Al sgg 1,000
Al yyy 50,000
Al zzzz 100,000
AL vv 39,000
Al wwww 40,000

I need a formula that says if Seller equals A1 (Bob), identify the accounts that are 80% of his total revenue.

This is the formula I have so far:
=IF(C6>(PERCENTILE(C$4:C$19,0.7)),"Top 80%","Bottom 20"%)

The issue is it returns the top 80% for ALL the accounts and not just the accounts for the seller I am referencing to the left. Does that make sense? I need some sort of sumif thrown in there to say label this top 80% if its top 80% of Joe's accounts, not everyones accounts. But need to be able to copy this throughout the excel spreadsheet of 100 sellers so i can't specifcally reference if A1="Joe", and can't quite figure out how to get it to do the percentile function with a SUMIF ---i tried this and its returning an error.

=IF(C4>(PERCENTILE(SUMIF(A4:A112,A4,C4:C112),0.7)),"Top 80%","Bottom 20"%)

DOES ANY OF THIS MAKE SENSE?

PLEASE HELP

Jackie