Excel sumif is not <>

Akbarov · Dec 14, 2018

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?

Fluff · Dec 14, 2018

Firstly, I'm actually a bloke, not a woman

Secondly, that portion of code does not help understand what you are trying to do.
Can you post some representative data to the site (there are some add-ins to help with that here https://www.mrexcel.com/forum/about-board/508133-attachments.html)
showing the columns that your formula is looking at.

joeu2004 · Dec 14, 2018

[.... deleted by me ....]

Akbarov · Dec 14, 2018

[TABLE="width: 1686"]
<tbody>[TR]
[TD="align: right"]434300[/TD]
[TD]ALBALI PET 1 LT[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41552095[/TD]
[TD="align: right"]2762565[/TD]
[TD="align: right"]21[/TD]
[TD]MARKET BAKIXANOV RAZIN 1[/TD]
[TD]300[/TD]
[TD]ZAUR YRAMOV[/TD]
[TD]QK[/TD]
[TD]KHAN SADIQOV[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]101900[/TD]
[TD]OLA PET 1 LT[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41553499[/TD]
[TD="align: right"]152556[/TD]
[TD="align: right"]0[/TD]
[TD]ZABRAT BAYISI[/TD]
[TD]320[/TD]
[TD]HABIL FTEROV[/TD]
[TD]QQ[/TD]
[TD]XTIYAR RUSTAMOV[/TD]
[TD="align: right"]280[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]280[/TD]
[/TR]
[TR]
[TD="align: right"]434300[/TD]
[TD]APPY ALBALI PET 1 LT[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41553309[/TD]
[TD="align: right"]5762569[/TD]
[TD="align: right"]0[/TD]
[TD]SAR M-T RAZIN[/TD]
[TD]300[/TD]
[TD]ZAUR BAAMOV[/TD]
[TD]QK[/TD]
[TD]OHAN SADIQOV[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]434300[/TD]
[TD]APPY ALBALI PET 1 LT[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41552145[/TD]
[TD="align: right"]6762562[/TD]
[TD="align: right"]0[/TD]
[TD]SAR MARKET AXUNDOV[/TD]
[TD]300[/TD]
[TD]ZAUR BAYMOV[/TD]
[TD]QS[/TD]
[TD]SAIR ISMAYILOV[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]434300[/TD]
[TD]APPY ALBALI PET 1 LT[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41552897[/TD]
[TD="align: right"]185691[/TD]
[TD="align: right"]0[/TD]
[TD]DAUD MARKET BILECERI[/TD]
[TD]300[/TD]
[TD]ZAUR BAAMOV[/TD]
[TD]QS[/TD]
[TD]SMIR ISMAYILOV[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]929700[/TD]
[TD]FANTA DUSES PET 0.5LX12[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41552640[/TD]
[TD="align: right"]177855[/TD]
[TD="align: right"]2[/TD]
[TD]ESCO-1 JALE PLAZA[/TD]
[TD]300[/TD]
[TD]ZAUR BAYMOV[/TD]
[TD]QS[/TD]
[TD]SIR ISMAYILOV[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]434300[/TD]
[TD]CAPPY ALBALI PET 1 LT[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41552657[/TD]
[TD="align: right"]177855[/TD]
[TD="align: right"]2[/TD]
[TD]ESCO-1 JALE PLAZA[/TD]
[TD]300[/TD]
[TD]ZAUR BAAMOV[/TD]
[TD]QS[/TD]
[TD]AMIR ISMAYILOV[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]641500[/TD]
[TD]USE TEA MANGO-CAMOMMILE P0.5[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41552921[/TD]
[TD="align: right"]177407[/TD]
[TD="align: right"]0[/TD]
[TD]HIPPER MARKET[/TD]
[TD]300[/TD]
[TD]ZAUR BAAMOV[/TD]
[TD]QS[/TD]
[TD]MIR ISMAYILOV[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]671200[/TD]
[TD]USE TEA QARPIZ PET 0,5LT[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41552921[/TD]
[TD="align: right"]177407[/TD]
[TD="align: right"]0[/TD]
[TD]HIPPER MARKET[/TD]
[TD]300[/TD]
[TD]ZAUR BAAMOV[/TD]
[TD]QS[/TD]
[TD]SAR ISMAYILOV[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]434300[/TD]
[TD]APPY ALBALI PET 1 LT[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41552202[/TD]
[TD="align: right"]4762572[/TD]
[TD="align: right"]21[/TD]
[TD] MARKET GENCE PROSPEKTI[/TD]
[TD]300[/TD]
[TD]UR BAYRAMOV[/TD]
[TD]QK[/TD]
[TD]OHAN SADIQOV[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]671200[/TD]
[TD]USE TEA QARPIZ PET 0,5LT[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41552814[/TD]
[TD="align: right"]179777[/TD]
[TD="align: right"]0[/TD]
[TD]BEEQROS MARKET[/TD]
[TD]300[/TD]
[TD]ZAUR BRAMOV[/TD]
[TD]QS[/TD]
[TD]SAM ISMAYILOV[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]434300[/TD]
[TD]APPY ALBALI PET 1 LT[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41552293[/TD]
[TD="align: right"]1818935[/TD]
[TD="align: right"]0[/TD]
[TD]AKRO MARKET MONTIN[/TD]
[TD]300[/TD]
[TD]ZAUR BRAMO[/TD]
[TD]QK[/TD]
[TD]ORKHAN SAQOV[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]641500[/TD]
[TD]USE TEA MANGO-CAMOMMILE P0.5[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41552624[/TD]
[TD="align: right"]4762570[/TD]
[TD="align: right"]0[/TD]
[TD]RAZ MARKET 6 MKR LIBRA[/TD]
[TD]300[/TD]
[TD]UR BAYRAMOV[/TD]
[TD]QS[/TD]
[TD]SAMIR ISMAYOV[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]671200[/TD]
[TD]SE TEA QARPIZ PET 0,5LT[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41553176[/TD]
[TD="align: right"]1814917[/TD]
[TD="align: right"]0[/TD]
[TD]EGA MARKET INQLAB[/TD]
[TD]300[/TD]
[TD]ZAUR BAYMOV[/TD]
[TD]QS[/TD]
[TD]SAMIR ISMILOV[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]641500[/TD]
[TD]USE TEA MANGO-CAMOMMILE P0.5[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41552681[/TD]
[TD="align: right"]176699[/TD]
[TD="align: right"]21[/TD]
[TD]RAZ MARKET OLIMPIKSTAR[/TD]
[TD]300[/TD]
[TD]ZAUR BAAMOV[/TD]
[TD]QS[/TD]
[TD]SAMIR ISMAYOV[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]929700[/TD]
[TD]NTA DUSES PET 0.5LX12[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41552681[/TD]
[TD="align: right"]176699[/TD]
[TD="align: right"]21[/TD]
[TD]RAZ MARKET OLIMPIKSTAR[/TD]
[TD]300[/TD]
[TD]ZAUR BAYROV[/TD]
[TD]QS[/TD]
[TD]SAMIR ISMAYOV[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]434300[/TD]
[TD]APPY ALBALI PET 1 LT[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41552103[/TD]
[TD="align: right"]1768354[/TD]
[TD="align: right"]18[/TD]
[TD]STORE MARKET AYGUN CITY[/TD]
[TD]300[/TD]
[TD]ZAUR BAAMOV[/TD]
[TD]QK[/TD]
[TD]ORKHAN SADOV[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]929700[/TD]
[TD]NTA DUSES PET 0.5LX12[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41552111[/TD]
[TD="align: right"]1768354[/TD]
[TD="align: right"]18[/TD]
[TD]STORE MARKET AYGUN CITY[/TD]
[TD]300[/TD]
[TD]ZR BAYROV[/TD]
[TD]QK[/TD]
[TD]ORKHAN SADOV[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]434300[/TD]
[TD]APPY ALBALI PET 1 LT[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41552558[/TD]
[TD="align: right"]6762574[/TD]
[TD="align: right"]0[/TD]
[TD]RAZ MARKET XIRDALAN BONUS[/TD]
[TD]300[/TD]
[TD]ZAUR BAYRV[/TD]
[TD]QS[/TD]
[TD]SAMIR ISMAYOV[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]641500[/TD]
[TD]SE TEA MANGO-CAMOMMILE P0.5[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41553036[/TD]
[TD="align: right"]2814912[/TD]
[TD="align: right"]0[/TD]
[TD]MGA MARKET QARACUXUR[/TD]
[TD]300[/TD]
[TD]ZAUR BRAMOV[/TD]
[TD]QK[/TD]
[TD]ORKHAN SADOV[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]434300[/TD]
[TD]APPY ALBALI PET 1 LT[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41552780[/TD]
[TD="align: right"]1754191[/TD]
[TD="align: right"]2[/TD]
[TD]ESCO-3 ASAN XIDMET[/TD]
[TD]300[/TD]
[TD]ZAUR BAYRV[/TD]
[TD]QS[/TD]
[TD]SAMIR ISMAYOV[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]641500[/TD]
[TD]USE TEA MANGO-CAMOMMILE P0.5[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41553192[/TD]
[TD="align: right"]185584[/TD]
[TD="align: right"]0[/TD]
[TD]MONO-3[/TD]
[TD]300[/TD]
[TD]ZAUR BAYMOV[/TD]
[TD]QK[/TD]
[TD]ORKHAN SADOV[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]101800[/TD]
[TD]OLA QUTU 250ML 1X24[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41552277[/TD]
[TD="align: right"]152282[/TD]
[TD="align: right"]0[/TD]
[TD]ADAG[/TD]
[TD]320[/TD]
[TD]HABIL SEEROV[/TD]
[TD]QQ[/TD]
[TD]BAXTIYAR RUAMOV[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]84[/TD]
[/TR]
[TR]
[TD="align: right"]929700[/TD]
[TD]NTA DUSES PET 0.5LX12[/TD]
[TD="align: right"]1180103[/TD]
[TD]ZAF41552210[/TD]
[TD="align: right"]176835[/TD]
[TD="align: right"]18[/TD]
[TD]STORE BABEK PROSPEKTI[/TD]
[TD]300[/TD]
[TD]ZAUR BAYMOV[/TD]
[TD]QK[/TD]
[TD]ORAN SADOV[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[/TR]
</tbody>[/TABLE]

List4
[TABLE="width: 72"]
<tbody>[TR]
[TD="width: 72, align: right"]152224[/TD]
[/TR]
[TR]
[TD="align: right"]152152[/TD]
[/TR]
[TR]
[TD="align: right"]152556[/TD]
[/TR]
[TR]
[TD="align: right"]152650[/TD]
[/TR]
[TR]
[TD="align: right"]152226[/TD]
[/TR]
[TR]
[TD="align: right"]152912[/TD]
[/TR]
[TR]
[TD="align: right"]152672[/TD]
[/TR]
[TR]
[TD="align: right"]152631[/TD]
[/TR]
[TR]
[TD="align: right"]152258[/TD]
[/TR]
[TR]
[TD="align: right"]152632[/TD]
[/TR]
[TR]
[TD="align: right"]152333[/TD]
[/TR]
[TR]
[TD="align: right"]152630[/TD]
[/TR]
[TR]
[TD="align: right"]152836[/TD]
[/TR]
[TR]
[TD="align: right"]152612[/TD]
[/TR]
[TR]
[TD="align: right"]152922[/TD]
[/TR]
[TR]
[TD="align: right"]152920[/TD]
[/TR]
[TR]
[TD="align: right"]152554[/TD]
[/TR]
[TR]
[TD="align: right"]152417[/TD]
[/TR]
[TR]
[TD="align: right"]152181[/TD]
[/TR]
[TR]
[TD="align: right"]152419[/TD]
[/TR]
[TR]
[TD="align: right"]152237[/TD]
[/TR]
[TR]
[TD="align: right"]152282[/TD]
[/TR]
[TR]
[TD="align: right"]152596[/TD]
[/TR]
[TR]
[TD="align: right"]152720[/TD]
[/TR]
[TR]
[TD="align: right"]152605[/TD]
[/TR]
[TR]
[TD="align: right"]152997[/TD]
[/TR]
[TR]
[TD="align: right"]152678[/TD]
[/TR]
[TR]
[TD="align: right"]152430[/TD]
[/TR]
[TR]
[TD="align: right"]152067[/TD]
[/TR]
[TR]
[TD="align: right"]152987[/TD]
[/TR]
[TR]
[TD="class: xl71, align: right"]152895[/TD]
[/TR]
</tbody>[/TABLE]

Don't even know what i'v just posted))

BTW sorry for Mrs

So i need to count if list E:E ( list3 ) is not on list4 at the same time M:M > 0

Fluff · Dec 14, 2018

In that list col M is all 0, so there is nothing to sum.

Akbarov · Dec 14, 2018

List is 500k row and M:M is my mistake it should be L:L

BTW list4 is in different sheet ("sheet4")

Fluff · Dec 14, 2018

With the data like

Excel 2013/2016

A

B

C

D

E

F

G

H

I

J

K

L

M

N

1

434300

ALBALI PET 1 LT

1180103

ZAF41552095

2762565

21

MARKET BAKIXANOV RAZIN 1

300

ZAUR YRAMOV

QK

KHAN SADIQOV

2

0

2

101900

OLA PET 1 LT

1180103

ZAF41553499

152556

0

ZABRAT BAYISI

320

HABIL FTEROV

QQ

XTIYAR RUSTAMOV

280

0

280

3

434300

APPY ALBALI PET 1 LT

1180103

ZAF41553309

5762569

0

SAR M-T RAZIN

300

ZAUR BAAMOV

QK

OHAN SADIQOV

3

0

3

4

434300

APPY ALBALI PET 1 LT

1180103

ZAF41552145

6762562

0

SAR MARKET AXUNDOV

300

ZAUR BAYMOV

QS

SAIR ISMAYILOV

5

0

5

434300

APPY ALBALI PET 1 LT

1180103

ZAF41552897

185691

0

DAUD MARKET BILECERI

300

ZAUR BAAMOV

QS

SMIR ISMAYILOV

1

6

929700

FANTA DUSES PET 0.5LX12

1180103

ZAF41552640

177855

2

ESCO-1 JALE PLAZA

300

ZAUR BAYMOV

QS

SIR ISMAYILOV

2

7

434300

CAPPY ALBALI PET 1 LT

1180103

ZAF41552657

177855

2

ESCO-1 JALE PLAZA

300

ZAUR BAAMOV

QS

AMIR ISMAYILOV

1

3

1

8

641500

USE TEA MANGO-CAMOMMILE P0.5

1180103

ZAF41552921

177407

0

HIPPER MARKET

300

ZAUR BAAMOV

QS

MIR ISMAYILOV

1

4

1

9

671200

USE TEA QARPIZ PET 0,5LT

1180103

ZAF41552921

177407

0

HIPPER MARKET

300

ZAUR BAAMOV

QS

SAR ISMAYILOV

1

0

1

10

434300

APPY ALBALI PET 1 LT

1180103

ZAF41552202

4762572

21

MARKET GENCE PROSPEKTI

300

UR BAYRAMOV

QK

OHAN SADIQOV

2

0

2

11

671200

USE TEA QARPIZ PET 0,5LT

1180103

ZAF41552814

179777

0

BEEQROS MARKET

300

ZAUR BRAMOV

QS

SAM ISMAYILOV

3

0

3

12

434300

APPY ALBALI PET 1 LT

1180103

ZAF41552293

1818935

0

AKRO MARKET MONTIN

300

ZAUR BRAMO

QK

ORKHAN SAQOV

8

0

8

13

641500

USE TEA MANGO-CAMOMMILE P0.5

1180103

ZAF41552624

4762570

0

RAZ MARKET 6 MKR LIBRA

300

UR BAYRAMOV

QS

SAMIR ISMAYOV

2

0

2

14

671200

SE TEA QARPIZ PET 0,5LT

1180103

ZAF41553176

1814917

0

EGA MARKET INQLAB

300

ZAUR BAYMOV

QS

SAMIR ISMILOV

2

0

2

15

641500

USE TEA MANGO-CAMOMMILE P0.5

1180103

ZAF41552681

176699

21

RAZ MARKET OLIMPIKSTAR

300

ZAUR BAAMOV

QS

SAMIR ISMAYOV

3

0

3

16

929700

NTA DUSES PET 0.5LX12

1180103

ZAF41552681

176699

21

RAZ MARKET OLIMPIKSTAR

300

ZAUR BAYROV

QS

SAMIR ISMAYOV

1

0

1

17

434300

APPY ALBALI PET 1 LT

1180103

ZAF41552103

1768354

18

STORE MARKET AYGUN CITY

300

ZAUR BAAMOV

QK

ORKHAN SADOV

5

0

5

18

929700

NTA DUSES PET 0.5LX12

1180103

ZAF41552111

1768354

18

STORE MARKET AYGUN CITY

300

ZR BAYROV

QK

ORKHAN SADOV

1

0

1

19

434300

APPY ALBALI PET 1 LT

1180103

ZAF41552558

6762574

0

RAZ MARKET XIRDALAN BONUS

300

ZAUR BAYRV

QS

SAMIR ISMAYOV

1

0

1

20

641500

SE TEA MANGO-CAMOMMILE P0.5

1180103

ZAF41553036

2814912

0

MGA MARKET QARACUXUR

300

ZAUR BRAMOV

QK

ORKHAN SADOV

4

0

4

21

434300

APPY ALBALI PET 1 LT

1180103

ZAF41552780

1754191

2

ESCO-3 ASAN XIDMET

300

ZAUR BAYRV

QS

SAMIR ISMAYOV

1

0

1

22

641500

USE TEA MANGO-CAMOMMILE P0.5

1180103

ZAF41553192

185584

0

MONO-3

300

ZAUR BAYMOV

QK

ORKHAN SADOV

1

0

1

23

101800

OLA QUTU 250ML 1X24

1180103

ZAF41552277

152282

0

ADAG

320

HABIL SEEROV

QQ

BAXTIYAR RUAMOV

84

0

84

24

929700

NTA DUSES PET 0.5LX12

1180103

ZAF41552210

176835

18

STORE BABEK PROSPEKTI

300

ZAUR BAYMOV

QK

ORAN SADOV

2

0

2

data

And sheet 4 like

Excel 2013/2016

C

AP

1

434300

152224

2

101900

152152

3

434300

152556

4

434300

152650

5

434300

152226

6

929700

152912

7

434300

152672

8

641500

152631

9

671200

152258

10

434300

152632

11

152333

12

152630

13

152836

14

152612

15

152922

16

152920

17

152554

18

152417

19

152181

20

152419

21

152237

22

152282

23

152596

24

152720

25

152605

26

152997

27

152678

28

152430

29

152067

30

152987

31

152895

sheet4

What is your expected answer?

Akbarov · Dec 14, 2018

If C <> AP
L:L>0
A:A is not blank
sum L:L
i need to sum all excepting AP:AP

Fluff · Dec 14, 2018

You code is looking to sum col M not L, maybe that is the problem.
If not please answer my question.

Akbarov · Dec 14, 2018

I get error[TABLE="width: 96"]
<tbody>[TR]
[TD="width: 96, align: center"]#N/A[/TD]
[/TR]
</tbody>[/TABLE]

Code:

Sub aqua()
    Dim Markets As Worksheet
    Set Markets = Sheets("sheet4")
    Sheets("DATA").Range("A:A").Name = "Urun"
    Sheets("DATA").Range("L:L").Name = "Sifaris"
    Sheets("DATA").Range("M:M").Name = "Printed"
    Sheets("DATA").Range("E:E").Name = "Musteri"
    Markets.Range("c1:c20").Name = "MARKET"
    Markets.Range("ap1:ap31").Name = "bayi"
    Sheets("DATA").Cells(5, "V") = [sum(if((isnumber(match(urun,market,0)))*(sifaris>0)*(urun<>"")*(musteri<>bayi),printed))]
End Sub

L:L are orders and M:M successfully sent orders and most of products are sold succesfully

Fluff · Dec 14, 2018

Try this

Code:

Sub Bonaqua()
    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(4, "V") = [sum(if((isnumber(match(list1,market,0)))*(list2>0)*(list1<>"")*(not(isnumber(match(list3,list4,0)))),printed))]
End Sub

Excel sumif is not <>

Akbarov

Active Member

Fluff

MrExcel MVP, Moderator

Excel Facts

joeu2004

Banned user

Akbarov

Active Member

Fluff

MrExcel MVP, Moderator

Akbarov

Active Member

Fluff

MrExcel MVP, Moderator

Akbarov

Active Member

Fluff

MrExcel MVP, Moderator

Akbarov

Active Member

Fluff

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

Excel sumif is not <>

Active Member

MrExcel MVP, Moderator

Excel Facts

Banned user

Active Member

MrExcel MVP, Moderator

Active Member

MrExcel MVP, Moderator

Active Member

MrExcel MVP, Moderator

Active Member

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock