View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nicuolt[_2_] nicuolt[_2_] is offline
external usenet poster
 
Posts: 1
Default help with formula

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