Hi Luciano,

Am Sat, 20 Jul 2013 14:34:11 -0700 (PDT) schrieb Luciano:

5.0
18.0
12.0 30.0
11.0
6.0
1.0
11.0
24.0
11.0
6.0
6.0
12.0
6.0 30.0
5.0
12.0

if you want to sum A:A with criteria in B:B is 30 then try:
=SUMIF(B1:B1000,30,A1:A1000)
If you want to find all values in A:A if criteria in B:B is 30 then try:
=IFERROR(INDEX($A$1:$A$1000,SMALL(IF(B$1:B$1000=30 ,ROW($1:$1000)),ROW(A1))),"")
and enter the array formula with CTRL+Shift+Enter and copy down.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2