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?

 

[Akbarov]

Thank you very much! you saved my day

 

[Fluff]

You're welcome & thanks for the feedback

 

[Akbarov]

Hi Mr. Fluff for some reason i get wrong result with your formula, any kind of help please? correct result is 95k but i get 80k result, on other calculation correct result is 12k but i get 8k result

 

[Fluff]

Without having your workbook, I have no way of knowing why you are not getting the expected results.
If, as you have said, your data is approx 500,000 rows. That is going to take quite a long time to figure things out & I am not willing to spend that amount of time on it.

 

[Akbarov]

i have found the problem, it is not

[COLOR=#333333]*(not(isnumber(match(list3,list4,0)))),printed))][/COLOR]

it is

[COLOR=#333333]*(not(isnumber(match(list4,list3,0)))),printed))][/COLOR]

it works fine as array formula, but not works as VBA
VBA running non-stop

any solution?

 

[Aladin Akyurek]

not(isnumber(match(list4,list3,0)))

should be

isna(match(list4,list3,0))

 

[Akbarov]

same problem VBA running non-stop

 

[Aladin Akyurek]

same problem VBA running non-stop

I was not talking about VBA. Addressing rather that formula expression with NOT...

 

[Akbarov]

i can't understand what is problem?

 

[Fluff]

@Akbarov

Now cross posted again https://www.excelforum.com/excel-pr...ut-running-non-stop-as-vba-2.html#post5028376
Please take the time to read the rules & abide by them