Count if statement with selective Counting

Good morning, I'm hoping someone can help me with a snag I've run into on a form I'm redesigning.

The User will be weighing product and entering weights into cells E30:E59. Specifications state that product must fall between a minimum and maximum weight, E13 and H13 respectively. E23 and E24 track the number of weighed products that fall over spec weight and under spec weight respectively. The challenge is that the measured weight is a gross weight. the formula must subtract a tare weight located in E21 in the form of a percent from the measured or gross weight before it tallies the weight as over or under spec.

Example:

E13 - Min=50
H13 - Max=100

E21 - Tare=10%

User weighs 5 products:

E30 = 108
E31 = 52
E32 = 125
E33 = 75
E34 = 160

E23 = 2 (125, 160 - Even though 108 is greater than 100, after the 10% tare weight is factored in, the net weight is no longer over spec)

E24 = 1 (even though the gross weight 52 is over the 50 minimum, after the 10% tare weight is factored in, the net weight falls under spec)

Up until I had to calculate the tare, the formula I was using looked like this:

Please Login or Register  to view this content.

I've played with it a little bit and tried to modify it to account for the tare weight.... but thus far have been unsucessful.

Thanks for your help

why not calculate the Tare weight : I13 =if(and(H13<>"",E21<>""),H13*(1-E21),"")

Then you can point E23 @ I13 etc...

Yes, that worked perfectly NBVC, thank you!

I see what you're saying Crimedog, I think that would have worked as well

Thank you!