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%")