Problem with formula

[Akbarov]

Hey Dear community,

I have problem with following formula

This is working formula

sum(if((isnumber(match(rn,mrkt,0)))*(sfs>0)*(urun<>"""")*(not(isnumber(match(mstr,by,0)))),printed))

But this one is not working

=sum(if((isnumber(match(rn,mrkt,0)))*(sfs>0)*(SUPPRESSCODE="M")*(urun<>"")*(not(isnumber(match(mstr,by,0)))),fark))

I can't find what is problem, can anyone help me please?

 

[RasGhul]

Hi

It looks like sumproduct may be more useful here, can you post some sample data so we can look at it?

 

[Akbarov]

Hi,

here is the full code

[COLOR=#333333]Sub Brn()[/COLOR]    Dim Markets As Worksheet
    Set Markets = Sheets("sheet4")
    Sheets("DATA").Range("A:A").Name = "run"
    Sheets("DATA").Range("L:L").Name = "aris"
    Sheets("DATA").Range("M:M").Name = "inted"
    Sheets("DATA").Range("E:E").Name = "steri"
    Sheets("sheet4").Range("AP:AP").Name = "byi"
    Markets.Range("e1:e10").Name = "MRET"
    With Sheets("DATA").Cells(5, "w")
    .FormulaArray = "=sum(if((isnumber(match(run,mret,0)))*(aris>0)*(run<>"""")*(not(isnumber(match(steri,byi,0)))),printed))"
    .Value = .Value
End With [COLOR=#333333]End Sub[/COLOR]

i just need to add 1 more criteria, inted=aris