listing accounts by criteria - error

[bluepenink]

hello

in my attached workbook....im trying to do a filter through a formula....i have bucketed my list of data by
a) sales person's tenure
b) region
c) revenue per deal


my sumprod gives shows me how many fall within my criteria but i want to take it further and list those individuals *this is where the problem lies*

=SMALL(IF(AND('SE 2011 Status'!$F$14:$F$305=Summary!$D$12,'SE 2011 Status'!$R$14:$R$305=Summary!$F$12),'SE 2011 Status'!$V$14:$V$305),K11) *ctrl shift end*

basically, my table shows i.e. 1 person whose revenue falls between $11-$31.99
i want to list that one person's revenue/ name in column L and M (see attached).

the "AND" aspect in my formula is throwing things off...also, i dont know how to place the logic for when i state "small" it finds that account!

pls help!​

the file is in the skydrive pls let me know thx u so much....
https://skydrive.live.com/redir.aspx?cid=ddc22c87a04e892b&resid=DDC22C87A04E892B!107&parid=root

 

[bluepenink]

any suggestions?!

 

[bluepenink]

any thoughts ....pls and thx u

 

[nodroj81]

Have you tried using a pivot table for this? I looked at your sheet and your data looks like it would work well with a pivot table.

 

[Aladin Akyurek]

any suggestions?!

AND would indeed not work...

Try rather:

=SMALL(IF('SE 2011 Status'!$R$14:$R$305=$F$12,IF('SE 2011 Status'!$F$14:$F$305=$D$12,'SE 2011 Status'!$V$14:$V$305)),K11)

which must be confirmed with control+shift+enter.