Excel sumif is not <>

[Akbarov]

Hey community,

i wanna know how can i ask excel to sum if list1 is not on list2



Sheets("DATA").Cells(5, "V") = [sum(if((isnumber(match(list1,list3,0)))*(sifaris>0)*(list1<>list2)*,printed))]
Can anybody help me please?

 

[James006]

Hello,

If your Array Formula - tested in your worksheet - already returns the correct result ...

Then ... - within your macro - you can use Evaluate ...

Hope this will help

 

[Akbarov]

sorry i don't understand
code works fine for me i only added *(list1<>list2) now it is not working

 

[Fluff]

Does your formula work if you put it into the cell?

 

[Akbarov]

no

 

[Fluff]

Then I would suggest getting the formula correct before trying to use it in VBA.

 

[Akbarov]

very helpfull..

 

[Fluff]

Considering that you have given us absolutely no information, other than a non working formula, what do you expect.
Surprising as it may seem, we are not mind readers

 

[Fluff]

Cross posted https://www.excelforum.com/excel-programming-vba-macros/1256527-excel-sumif.html#post5027131

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Akbarov]

i thought it is not VBA question for that reason i posted in here

so as you see

<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">

Dim Markets As Worksheet
    Set Markets = Sheets("sheet4")
    Sheets("DATA").Range("A:A").Name = "list1"
    Sheets("DATA").Range("L:L").Name = "list2"
    Sheets("DATA").Range("M:M").Name = "Printed"
    Sheets("DATA").Range("E:E").Name = "list3"
    Sheets("sheet4").Range("AP:AP").Name = "list4"
    Markets.Range("c1:c20").Name = "MARKET"
    Sheets("DATA").Cells(5, "V") = [sum(if((isnumber(match(list1,market,0)))*(list2>0)*(list1<>"")*(list3<>list4),printed))]

</code>
before adding *(list3<>list4) it worked fine, list3 and list4 are numeric lists i want it to calculate if id number in list3 is not in list4 ( list4 is in different sheet if that makes sense ) list3 is about 500k row
Any kind of help Mrs Fluff?