# Problem with formula

#### Akbarov

##### Board Regular
Hey Dear community,

I have problem with following formula

This is working formula
Code:
``sum(if((isnumber(match(rn,mrkt,0)))*(sfs>0)*(urun<>"""")*(not(isnumber(match(mstr,by,0)))),printed))``
But this one is not working
Code:
``=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?

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

#### RasGhul

##### Well-known Member
Hi

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

#### Akbarov

##### Board Regular
Hi,

here is the full code

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