Hi, I'm trying to set a formula to find which item are driven 80% sell thru. What I did now is i need to change the 10.5% everything time i added a new data.


column D
=COUNTIF(C2:C10,"10.5%")


column E
=SUMIF(C2:C10,"10.5%")

Post an example workbook showing before and after.

And you need to explain what you mean by "Driven". It makes no sense.

sorry it should be an item driven 80% in total.

That doesn't help anyone understand what you mean by driven!

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?

Here's the workbook.

No, that's a picture of the workbook. It helps nobody!

Until you can provide a workbook with your current formulas and an explanation of WHAT you're trying to achieve and WHY what you currently have isn't good enough, nobody will be able to help you!!!!!!!

Hi, my apologize to confused you.

I need to find the fewest items that sum to about 80% or closest to 80% in column C.