Originally Posted by LF.TEN

B 300 19.2%
C 20 1.3%
D 1 0.1%
E 30 1.9%
F 4 0.3%
G 5 0.3%
H 600 38.5%
I 500 32.1%


Ok let put it this way. The above items that drive 80% sell thru in total is item b, H & I. So i need to find out a formula to find which item are driving 80% or more in the above table. So I ended up using =COUNTIF(C2:C10,"10.5%") and the answer is 3 items and the total % from this 3 items is 80% ++. From this total % I'm using =SUMIF(C2:C10,"10.5%"). My question is is that any other way for me to find which items are driving 80% sales?