This one makes more sense.

Where these conditions are true:
The formula is array-entered using CTRL+SHIFT+ENTER

The distance between eligible rows is never more than 4999 rows (if this is
not the case, change the 5000s to 10000s or more).

You meant the next date/price that meets all conditions implied by your
formula.

The references to Comenzi are meant to be absolute.

The COD column is all text and the comenzi reference is text OR the COD
column is all numbers and the comenzi reference is numbers

In cell G2:

The formula for date is:
=IF(AND(F2=0,B2=Comenzi!$D$8,C2=Comenzi!$E$8),INDE X(A2:A5000,MATCH(1,(F2:$F5000<0)*(B2:B5000=Comenz i!$D$8)*(C2:C5000=Comenzi!$E$8),0)),A2)

The formula for price is:
=IF(AND(F2=0,B2=Comenzi!$D$8,C2=Comenzi!$E$8),INDE X(E2:E5000,MATCH(1,(F2:$F5000<0)*(B2:B5000=Comenz i!$D$8)*(C2:C5000=Comenzi!$E$8),0)),E2)

"nicuolt" wrote:

DATA COD Marime Intrate Price Ramase
12/2/09 8167 44-46 10 57.68 5
21/1/09 8167 44-46 10 58.08 0
7/1/09 8167 44-46 10 54.85 10

Formula is
=SUMIFS(E:E,Stoc!B:B,Comenzi!D8,C:C,Comenzi!E8,F:F ,"0",A:A,MIN(A:A)) but not
work. I want the next date or next price if F:F = 0.
If F:F=0, result 0.
needing a formulas

TKS