SMALLIFS? (How to use SMALL function to behave as if it were SMALLIFS similar to SUMIFS/COUNTIFS?

[MEUserII]

Is there a way to use the SMALL function, so it works as if it were SMALLIFS? Specifically, both SUMIFS and COUNTIFS allow for dynamic range construction for the SUM calculation and COUNT calculation. I want to do the same thing with the SMALL function; how would I do this? I have listed some test data below to help explain what I am trying to do. _________[Column A]____[Column B]____[Column C]____[Column D]____[Column E] [Row 1]__[____a___]____[____b___]____[____d___]____[____f___]____[____5___] [Row 2]__[____a___]____[____b___]____[____d___]____[____f___]____[____4___] [Row 3]__[____a___]____[____b___]____[____d___]____[____g___]____[____3___] [Row 4]__[____a___]____[____b___]____[____e___]____[____g___]____[____2___] [Row 5]__[____a___]____[____c___]____[____e___]____[____g___]____[____1___] [Row 6]__ If I wanted to enter a formula in A6 that SUMs all values in Column E (E1:E5) with only the following conditions: Column A=a, Column b=c, Column C=e it would be: SUMIFS( $E$1:$E$5, $A$1:$A$5, A1, $B$1:$B$5, B1, $B$1:$B$5, B4) Which when evaluated is: = (2)+(1) (As in only E4 and E5 meet the conditions above.) How would I do this same thing for the SMALL function? Only take the SMALL function of the values in E ONLY where: Column A=a, Column B=c, Column C=e? Basically something like: SMALL( $E$1:$E$5, $A$1:$A$5, A1, $B$1:$B$5, B1, $B$1:$B$5, B4)???

 

[Aladin Akyurek]

Hard to follow. Try to post the sample that is readable along with the expected outcome?