Excel sumif is not <>

Akbarov

Active Member
Joined
Jun 30, 2018
Messages
347
Office Version
  1. 365
Platform
  1. Windows
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?
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
You're welcome & thanks for the feedback
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
i have found the problem, it is not
Code:
[COLOR=#333333]*(not(isnumber(match(list3,list4,0)))),printed))][/COLOR]
it is
Code:
[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?
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,998
Members
448,539
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top