Quote:
Originally Posted by LF.TEN
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.