Hi,
Am Sun, 31 Aug 2014 08:26:07 -0700 (PDT) schrieb (e-mail address removed):
try:
=SUMIFS(A1:A1000,A1:A1000,">3",A1:A1000,"<="&SMALL(A1:A1000,COUNTIF(A1:A1000,"<=3")+3))
or
=SUMPRODUCT(--(A1:A1000>3),--(A1:A1000<=SMALL(A1:A1000,COUNTIF(A1:A1000,"<=3")+3)),A1:A1000)
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional