Problem with formula

Akbarov

Board Regular
Joined
Jun 30, 2018
Messages
97
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?
 

Some videos you may like

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
Joined
Jul 15, 2016
Messages
609
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
Joined
Jun 30, 2018
Messages
97
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
 

Watch MrExcel Video

Forum statistics

Threads
1,098,989
Messages
5,465,849
Members
406,450
Latest member
gunner12

This Week's Hot Topics

Top