I have a row of numerical values that contain a zero in some cells. I want to count the smallest eight values excluding the cells with zero values. A number of cells have the same value, e.g. there could, conceivably, be more than eight with the lowest value. Does this have an impact on the formula?
I have attempted to modify the formula to insert the element that will ignore any zero values without any success.
The formula will be entered into cell E6.
My current formula is =SUMPRODUCT(SMALL(D13:D64,{1,2,3,4,5,6.7.8}))/C3. How do I correct this formula to so that cells with a zero value are ignored?
Thanks in advance
D
I have attempted to modify the formula to insert the element that will ignore any zero values without any success.
The formula will be entered into cell E6.
My current formula is =SUMPRODUCT(SMALL(D13:D64,{1,2,3,4,5,6.7.8}))/C3. How do I correct this formula to so that cells with a zero value are ignored?
Thanks in advance
D