Spreadsheet: 846747d1697895828-find-out-count-of-specific-products-invoice-by-sales-representatives-excel-2-v2
Sheet: Sheet1

SR NAME | INVOICE NO. | ITEMNAME | QTY |  | EXPECTED RESULT |  |  | CONDITIONS |  |  | THE CONDITION IS , HERE I NEED TO CHECK HOW MUCH MARKS EACH SALES REPRESENTATIVE'S HAS GOT. HERE ARE 6 SRs. I NEED TO CHECK IN ANY SINGLE MEMO HOW MANY ITEM'S HAS INVOICE QTYs.   SUPPOSE, HERE THE  FIRST INVOICE NO. BILL230008869 HAS 3 ITEMS, AND ID THOSE ITEM'S QTY MATCHES WITH THE CONDITION HE'LL GET 1 POINT i.e. EC FOR THE SINGLE ITEMS. SO HERE IN THIS INVOICE NO. BILL230008869 ALL OF THE CONDITIONS MATCHES WITH REQUIREMENTS WHICH IS "EQUAL TO OR GREATER THAN 2", SO HE GETS 3 MARKS FOR THAT SINGLE BILL.   I NEED THIS RESULT AS I MENTIONED BY SALES REPRESENTATIVES & BY UNIQUE INVOICE NO.
Sajal Kanti Das | BILL230008869 | PCNO 40ML BICOL NMRP | 12 |  | SR NAME | TOTAL EC |  | ITEMNAME | QTY REQUIREMENT | EC VALUE
Sajal Kanti Das | BILL230008869 | SP LOTION NM 200ML NMRP-1 | 4 |  |  | 5 |  |  | >=2 | 1
Sajal Kanti Das | BILL230008872 | PCNO 350ML BICOL NMRP | 2 |  | Deloar | 9 |  | SP LOTION NM 200ML NMRP-1 | >=2 | 1
Sajal Kanti Das | [NAME] | PCNO 40ML BICOL NMRP | 12 |  | [NAME] | 4 |  | PCNO 350ML BICOL NMRP | >=2 | 1
Sajal Kanti Das | BILL230008905 | BELIPHOOL 35ML NMRP-2 | 24 |  | [NAME] | 5 |  | BELIPHOOL 35ML NMRP-2 | >=3 | 1
Deloar | BILL230008908 | BELIPHOOL 35ML NMRP-2 | 36 |  | PSR(Sajol Kumar) | 2 |  | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | >=3 | 1
Deloar | BILL230008908 | PCNO 40ML BICOL NMRP | 24 |  | [NAME] | 9 |  | JFB OIL 210TK 72X100ML | >=1 | 1
Deloar | BILL230008908 | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 3 |  |  |  |  | BELIPHOOL 300ML NMRP-1 | >=1 | 1
Deloar | BILL230008909 | JFB OIL 210TK 72X100ML | 6 |  |  |  |  | BELI CO (F 30 ML) [NAME] | >=1 | 1
Deloar | BILL230008957 | BELIPHOOL 300ML NMRP-1 | 3 |  |  |  |  | PCNO 500ML BICOL NMRP | >=1 | 1
Deloar | BILL230008957 | JFB OIL 210TK 72X100ML | 3 |  |  |  |  | BELIPHOOL 100ML NMRP-3 | >=12 | 1
Deloar | BILL230008958 | BELI CO (F 30 ML) [NAME] | 9 |  |  |  |  | PCNO 100ML BICOL NMRP | >=1 | 1
Deloar | BILL230008959 | BELIPHOOL 35ML NMRP-2 | 24 |  |  |  |  | JFB FACE CREAM 130TK 48X50G | >=1 | 1
Deloar | BILL230008959 | PCNO 500ML BICOL NMRP | 2 |  |  |  |  | SP LOTION NM 310TK 24X300ML | >=1 | 1
[NAME] | BILL230013773 | BELIPHOOL 100ML NMRP-3 | 6 |  |  |  |  | PA AV Oil 165TK 96X150ML | >=1 | 1
[NAME] | BILL230013773 | PCNO 40ML BICOL NMRP | 12 |  |  |  |  | BELIPHOOL 200ML NMRP-3 | >=1 | 1
[NAME] | BILL230013780 | PCNO 100ML BICOL NMRP | 4 |  |  |  |  | PCNO 500ML CO(75ML EXTRA) BICOL NMRP | >=1 | 1
[NAME] | BILL230013780 | PCNO 100ML BICOL NMRP | 20 |  |  |  |  | PCNO CO (F 20ML) 155TK 72X220ML | >=1 | 1
[NAME] | BILL230013780 | BELIPHOOL 100ML NMRP-3 | 24
[NAME] | BILL230013785 | PCNO 100ML BICOL NMRP | 12
[NAME] | BILL230013787 | PCNO 40ML BICOL NMRP | 12
PSR(Sajol Kumar) | BILL230013805 | BELIPHOOL 100ML NMRP-3 | 39
PSR(Sajol Kumar) | BILL230013805 | BELIPHOOL 100ML NMRP-3 | 105
PSR(Sajol Kumar) | BILL230013805 | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 6
PSR(Sajol Kumar) | BILL230013805 | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 78
[NAME] | BILL230013807 | JFB FACE CREAM 130TK 48X50G | 2
[NAME] | BILL230013807 | PCNO 500ML BICOL NMRP | 1
[NAME] | BILL230013807 | SP LOTION NM 310TK 24X300ML | 1
[NAME] | BILL230013810 | PCNO 100ML BICOL NMRP | 12
[NAME] | BILL230013810 | PCNO 40ML BICOL NMRP | 12
[NAME] | BILL230013810 | BELI CO (F 30 ML) [NAME] | 6
[NAME] | BILL230013849 | PA AV Oil 165TK 96X150ML | 2
[NAME] | BILL230013850 | PA AV Oil 165TK 96X150ML | 0
[NAME] | BILL230013855 | PCNO CO (F PNS NC 2X5ML) 155TK 84X200ML | 6
[NAME] | BILL230014123 | BELIPHOOL 200ML NMRP-3 | 0
[NAME] | BILL230014124 | BELIPHOOL 100ML NMRP-3 | 6
[NAME] | BILL230014821 | PCNO 500ML CO(75ML EXTRA) BICOL NMRP | 1
[NAME] | BILL230014837 | PCNO CO (F 20ML) 155TK 72X220ML | 6
[NAME] | BILL230014999 | PCNO 500ML CO(75ML EXTRA) BICOL NMRP | 1
[NAME] | BILL230015000 | PCNO 500ML CO(75ML EXTRA) BICOL NMRP | 1