Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please - help with formula
The problems are he Sheet Comenzi!D8"=8167"
and he "=44-46" It won't recognize equality in that syntax. Remove the equal sign and the quotes and change the range to greaterthan or equal to and less than or equal to conditions. I think the formula you want is this: =SUMIFS(E:E,Stoc!B:B,8167,C:C,"=44",C:C,"<=46",F: F,"0",A:A,MIN(A:A)) "nicuolt" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|