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

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

formula IS: =SUMIFS(E:E,Stoc!B:B,Sheet Comenzi!D8"=8167",C:C,Sheet
Comenzi!E8"=44-46",F:F,"0",A:A,MIN(A:A))...
I want to rezult NEXT date or NEXT Price if F:F = 0!

if in F2=0, or F4=0, rezult 0. I have this problem!

thanks in advance.