Spreadsheet: 793248d1661363269-look-up-for-the-value-in-column-and-return-sum-if-condition-match-two-condition-sum
Sheet: Sheet1

Sr. | Account No | Amount | COUNTER NO
1 | 58641000097 | 1680 | 12
2 | 58641000100 | 1450 | 12
3 | 58641000135 | 2850 | 12
4 | 58641000178 | 1880 | 12
5 | 58641000194 | 960 | 12
6 | 58641000267 | 3200 | 12
7 | 58641000283 | 2030 | 12
8 | 58641000356 | 1800 | 12
9 | 58641000364 | 1880 | 12
10 | 58641000410 | 3600 | 12
11 | 58641000429 | 2200 | 12
12 | 58641000500 | 450 | 12
13 | 58641000569 | 1360 | 12
14 | 58641000577 | 440 | 12
15 | 58641000780 | 1100 | 12
16 | 58641000801 | 1300 | 12
17 | 58641000836 | 260 | 12
18 | 58641000860 | 680 | 12
19 | 58641001034 | 780 | 12
20 | 58641001069 | 110 | 12
21 | 58641001085 | 130 | 12
22 | 58641001158 | 2220 | 12
23 | 58641001239 | 1500 | 12
24 | 58641001247 | 1710 | 12
25 | 58641001263 | 30 | 12
26 | 58641001280 | 1330 | 12
27 | 58641001352 | 1660 | 12
28 | 58641001549 | 1000 | 12
29 | 58641001603 | 900 | 12
30 | 58641001654 | 440 | 12
31 | 58641001662 | 810 | 12
32 | 58641001670 | 3530 | 12
33 | 58641001735 | 2160 | 12
34 | 58641001778 | 180 | 12
35 | 58641001794 | 850 | 12
36 | 58641001808 | 1080 | 12
37 | 58641001824 | 150 | 12
38 | 58641001840 | 1020 | 12
39 | 58641001875 | 3330 | 12
40 | 58641002006 | 640 | 12
41 | 58641002014 | 1180 | 12
42 | 58641002073 | 700 | 12
43 | 58641002260 | 1110 | 12
44 | 58641002278 | 220 | 12
45 | 58641002324 | 4450 | 12
46 | 58641002448 | 2320 | 12
47 | 58641002456 | 3120 | 12
48 | 58641002510 | 3610 | 12
49 | 58641002634 | 700 | 12
50 | 58641002669 | 520 | 12
51 | 58641002812 | 540 | 12
52 | 58641002898 | 2960 | 12
53 | 58641002910 | 1060 | 12
54 | 58641002960 | 1170 | 12
55 | 58641002995 | 240 | 12
56 | 58641003185 | 529 | 1
57 | 58641003185 | 10000 | 1
58 | 58641003428 | 1450 | 12
59 | 58641003541 | 4000 | 12
60 | 58641003576 | 1270 | 12
61 | 58641003657 | 40 | 12
62 | 58641004289 | 1100 | 1
63 | 58641004289 | 1100 | 99
64 | 58641004572 | 2070 | 1
65 | 58641004572 | 5000 | 1
66 | 58641005030 | 10000 | 1
67 | 58641005030 | 10000 | 1
68 | 58641006133 | 460 | 12
69 | 58641006214 | 700 | 12
70 | 58641006222 | 1020 | 12
71 | 58641006273 | 1700 | 12
72 | 58641006290 | 460 | 12
73 | 58641006303 | 250 | 12
74 | 58641006419 | 110 | 12
75 | 58641006427 | 80 | 12
76 | 58641006478 | 800 | 12
77 | 58641006583 | 810 | 12
78 | 58641006699 | 1400 | 12
79 | 58641006702 | 1490 | 12
80 | 58641006761 | 500 | 12
81 | 58641006869 | 500 | 12
82 | 58641006877 | 170 | 12
83 | 58641006885 | 1580 | 12
84 | 58641006923 | 830 | 12
85 | 58641006931 | 1240 | 12
86 | 58641006940 | 1520 | 12
87 | 58641006974 | 1350 | 12
88 | 58641007040 | 1430 | 12
89 | 58641007059 | 2270 | 12
90 | 58641007067 | 1300 | 12
91 | 58641007180 | 650 | 12
92 | 58641007199 | 500 | 12
93 | 58641007237 | 910 | 12
94 | 58641007245 | 660 | 12
95 | 58641007253 | 1040 | 12
96 | 58641007270 | 370 | 12
97 | 58641007377 | 300 | 12
98 | 58641007466 | 900 | 12
99 | 58641007660 | 200 | 12
100 | 58641007679 | 1300 | 12
101 | 58641007776 | 30 | 12
102 | 58641007784 | 2970 | 12
103 | 58641007857 | 1490 | 12
104 | 58641008055 | 320 | 12
105 | 58641008101 | 30 | 12
106 | 58641008110 | 1130 | 12
107 | 58641008160 | 620 | 12
108 | 58641008225 | 410 | 12
109 | 58641008233 | 440 | 12
110 | 58641008314 | 510 | 12
111 | 58641008349 | 1800 | 12
112 | 58641008357 | 940 | 12
113 | 58641008365 | 1870 | 12
114 | 58641008390 | 430 | 12
115 | 58641008420 | 1500 | 12
116 | 58641008446 | 740 | 12
117 | 58641008489 | 460 | 12
118 | 58641008500 | 780 | 12
119 | 58641008519 | 760 | 12
120 | 58641008535 | 240 | 12
121 | 58641008640 | 960 | 12
122 | 58641008934 | 1500 | 12
123 | 58641008950 | 1090 | 12
124 | 58641008993 | 810 | 12
125 | 58641009027 | 960 | 12
126 | 58641009094 | 210 | 12
127 | 58641009329 | 1070 | 12
128 | 58641009426 | 860 | 12
129 | 58641009442 | 760 | 12
130 | 58641009485 | 50 | 12
131 | 58641009515 | 190 | 12
132 | 58641009523 | 1640 | 12
133 | 58641009582 | 450 | 12
134 | 58641009612 | 500 | 99
135 | 58641009612 | 1000 | 99
136 | 58641009655 | 1780 | 12
137 | 58641009663 | 1100 | 12
138 | 58641009671 | 2050 | 12
139 | 58641009680 | 300 | 12
140 | 58641009779 | 50 | 99
141 | 58641009779 | 150 | 99
142 | 58641009795 | 510 | 12
143 | 58641009817 | 1500 | 12
144 | 58641009825 | 1890 | 12
145 | 58641009850 | 1160 | 12
146 | 58641009884 | 2030 | 12
147 | 58641009949 | 950 | 12
148 | 58641010017 | 710 | 12
149 | 58641010050 | 1120 | 12
150 | 58641010068 | 560 | 12
151 | 58641010114 | 380 | 12
152 | 58641010130 | 1230 | 12
153 | 58641010432 | 810 | 12
154 | 58641010718 | 840 | 12
155 | 58641010734 | 600 | 12
156 | 58641100016 | 640 | 12
157 | 58641100032 | 380 | 12
158 | 58641100040 | 260 | 12
159 | 58641100059 | 3760 | 12
160 | 58641100148 | 1 | 99
161 | 58641100148 | 100 | 99
162 | 58641100148 | 2486 | 99
163 | 58641100164 | 900 | 12
164 | 58641100245 | 1850 | 12
165 | 58641100300 | 150 | 12
166 | 58641100334 | 1640 | 12
167 | 58641100601 | 30 | 12
168 | 58641100610 | 540 | 12
169 | 58641100733 | 450 | 12
170 | 58641100768 | 180 | 12
171 | 58641100946 | 1040 | 12
172 | 58641101152 | 1320 | 12
173 | 58641101268 | 2680 | 12
174 | 58641101306 | 760 | 12
175 | 58641101527 | 2200 | 1
176 | 58641101527 | 10000 | 1
177 | 58641101543 | 400 | 12
178 | 58641101586 | 500 | 12
179 | 58641101683 | 100 | 99
180 | 58641101683 | 2500 | 99
181 | 58641101691 | 840 | 12
182 | 58641101772 | 1190 | 12
183 | 58641102051 | 30 | 12
184 | 58641102132 | 2180 | 12
185 | 58641102159 | 1000 | 12
186 | 58641102566 | 1049 | 99
187 | 58641102566 | 1049 | 99
188 | 58641102728 | 2180 | 12
189 | 58641102841 | 1370 | 12
190 | 58641103074 | 1220 | 12
191 | 58641103120 | 850 | 12
192 | 58641103163 | 1790 | 12
193 | 58641103180 | 750 | 12
194 | 58641103252 | 2170 | 12
195 | 58641103805 | 1460 | 12
196 | 58641103813 | 1120 | 12
197 | 58641103830 | 14 | 1
198 | 58641103830 | 1386 | 1
199 | 58641103902 | 1200 | 12
200 | 58641103929 | 480 | 12
201 | 58641104089 | 900 | 1
202 | 58641104089 | 2050 | 1
203 | 58641104089 | 10000 | 1
204 | 58641104399 | 950 | 12
205 | 58641104429 | 1530 | 12
206 | 58641104496 | 1580 | 12
207 | 58641104747 | 50 | 12
208 | 58641104828 | 1420 | 12
209 | 58641104925 | 1070 | 12
210 | 58641105310 | 60 | 1
211 | 58641105310 | 60 | 1
212 | 58641105522 | 780 | 12
213 | 58641105590 | 8350 | 12
214 | 58641106073 | 560 | 12
215 | 58641106138 | 4180 | 12
216 | 58641106286 | 260 | 1
217 | 58641106286 | 4650 | 1
218 | 58641106294 | 2790 | 12
219 | 58641106316 | 5550 | 12
220 | 58641106359 | 780 | 12
221 | 58641106367 | 700 | 12
222 | 58641106375 | 310 | 12
223 | 58641106413 | 1820 | 12
224 | 58641106502 | 160 | 12
225 | 58641106529 | 12 | 1
226 | 58641106529 | 10000 | 1
227 | 58641106626 | 900 | 12
228 | 58641106669 | 570 | 12
229 | 58641106936 | 440 | 12
230 | 58641107096 | 80 | 12
231 | 58641107266 | 1940 | 12
232 | 58641107282 | 30 | 12
233 | 58641107665 | 10 | 12
234 | 58641107673 | 20 | 12
235 | 58641107690 | 2380 | 12
236 | 58641107754 | 1990 | 12
237 | 58641107770 | 570 | 12
238 | 58641108122 | 1 | 99
239 | 58641108122 | 1 | 99
240 | 58641108122 | 1000 | 99
241 | 58641108122 | 3600 | 99
242 | 58641108190 | 290 | 12
243 | 58641108211 | 1500 | 12
244 | 58641108394 | 1000 | 1
245 | 58641108394 | 2 | 99
246 | 58641108424 | 1600 | 12
247 | 58641108483 | 1550 | 12
248 | 58641108548 | 470 | 12
249 | 58641108653 | 1630 | 12
250 | 58641108700 | 1410 | 12
251 | 58641108831 | 5050 | 12
252 | 58641108882 | 370 | 12
253 | 58641109315 | 290 | 12
254 | 58641109366 | 1400 | 12
255 | 58641109439 | 1120 | 12
256 | 58641109528 | 540 | 12
257 | 58641109943 | 8000 | 1
258 | 58641109943 | 10000 | 1
259 | 58646002276 | 4300 | 1
260 | 58646002276 | 10000 | 1
261 | 58646003515 | 700 | 1
262 | 58646003515 | 10000 | 1
263 | 58646100740 | 3000 | 99
264 | 58646100740 | 50000 | 99
265 | 58646101061 | 0.8 | 1
266 | 58646101061 | 1090 | 1
267 | 58646103706 | 7614 | 99
268 | 58646103706 | 21313 | 99
269 | 82715004553 | 10000 | 1
270 | 82715004553 | 10000 | 1
271 | 82715012831 | 200 | 99
272 | 82715012831 | 200 | 99
273 | 82715012831 | 784 | 99
274 | 82715016926 | 0.2 | 1
275 | 82715016926 | 0.2 | 1
276 | 82715016926 | 0.2 | 1
277 | 82715016926 | 0.4 | 1
278 | 82715016926 | 0.4 | 1
279 | 82715016926 | 0.4 | 1
280 | 82715016926 | 0.4 | 1
281 | 82715016926 | 0.6 | 1
282 | 82715016926 | 1 | 1
283 | 82715020400 | 500 | 3
284 | 82715020400 | 500 | 1
285 | 82715111678 | 1600 | 1
286 | 82715111678 | 2500 | 1
287 | 82715114120 | 100 | 99
288 | 82715114120 | 6000 | 99
289 | 82715114847 | 100 | 99
290 | 82715114847 | 500 | 99
291 | 82715116920 | 2500 | 1
292 | 82715116920 | 10 | 99
293 | 82715118427 | 420 | 1
294 | 82715118427 | 5580 | 1
295 | 82715118427 | 10000 | 1
296 | 82715118923 | 500 | 3
297 | 82715118923 | 500 | 1
298 | 82715120120 | 50 | 99
299 | 82715120120 | 3748.65 | 99
300 | 82715121266 | 3.8 | 1
301 | 82715121266 | 8.2 | 1
302 | 82715122742 | 2850 | 1
303 | 82715122742 | 10000 | 1
304 | 82715122742 | 10000 | 1
305 | 82721002923 | 150 | 1
306 | 82721002923 | 1400 | 1
307 | 82721004063 | 50000 | 1
308 | 82721004063 | 10000 | 1
309 | 82721004349 | 1200 | 1
310 | 82721004349 | 9900 | 1
311 | 82721004551 | 1200 | 1
312 | 82721004551 | 9900 | 1
313 | 82721101697 | 400 | 1
314 | 82721101697 | 10000 | 1
315 | 82721101921 | 41100 | 1
316 | 82721101921 | 800 | 1
317 | 82721102138 | 3700 | 1
318 | 82721102138 | 10000 | 1
319 | 82722102077 | 9450 | 1
320 | 82722102077 | 10000 | 1
321 | 82722102077 | 10000 | 1
322 | 82723002246 | 3680 | 1
323 | 82723002246 | 10000 | 1
324 | 82723003102 | 460 | 1
325 | 82723003102 | 670 | 1
326 | 82723004648 | 7100 | 1
327 | 82723004648 | 10000 | 1
328 | 82723004842 | 3880 | 3
329 | 82723004842 | 3880 | 3
330 | 82723103328 | 7400 | 1
331 | 82723103328 | 10000 | 1
332 | 82723103328 | 10000 | 1
333 | 82725000470 | 10000 | 1
334 | 82725000470 | 10000 | 1
335 | 82725100849 | 4200 | 1
336 | 82725100849 | 10000 | 1
337 | 82726002204 | 2000 | 99
338 | 82726002204 | 3535 | 99
339 | 82726002573 | 3170 | 1
340 | 82726002573 | 10000 | 1
341 | 82726002590 | 7000 | 1
342 | 82726002590 | 10000 | 1
343 | 82726002590 | 10000 | 1
344 | 82726002590 | 10000 | 1
345 | 82726002972 | 1080 | 1
346 | 82726002972 | 10000 | 1
347 | 82726003545 | 1000 | 1
348 | 82726003545 | 10000 | 1
349 | 82726003995 | 10000 | 1
350 | 82726003995 | 10000 | 1
351 | 82726005025 | 2500 | 1
352 | 82726005025 | 5720 | 1
353 | 82726005025 | 10000 | 1
354 | 82726100907 | 70 | 1
355 | 82726100907 | 1770 | 1
356 | 82726101091 | 600 | 99
357 | 82726101091 | 950 | 99
358 | 82726101903 | 230 | 1
359 | 82726101903 | 300 | 1
360 | 82726101903 | 770 | 1
361 | 82743001750 | 1230 | 1
362 | 82743001750 | 660 | 99
363 | 82743002578 | 1 | 1
364 | 82743002578 | 155 | 1
365 | 82743003078 | 2620 | 1
366 | 82743003078 | 10000 | 1
367 | 82743003825 | 570 | 1
368 | 82743003825 | 10000 | 1
369 | 82743004651 | 360 | 99
370 | 82743004651 | 1600 | 99
371 | 82743005496 | 9155 | 1
372 | 82743005496 | 10000 | 1
373 | 82743005704 | 890 | 1
374 | 82743005704 | 10000 | 1
375 | 82743005968 | 20 | 1
376 | 82743005968 | 4760 | 1
377 | 82743006972 | 5000 | 1
378 | 82743006972 | 10000 | 1
379 | 82743100545 | 4020 | 3
380 | 82743100545 | 10000 | 3
381 | 82743103900 | 430 | 1
382 | 82743103900 | 10000 | 1
383 | 82749003959 | 65 | 3
384 | 82749003959 | 920 | 3
385 | 82749004084 | 5000 | 1
386 | 82749004084 | 10000 | 1
387 | 82749004106 | 10000 | 3
388 | 82749004106 | 10000 | 3
389 | 82749008101 | 300 | 3
390 | 82749008101 | 400 | 3
391 | 82749102604 | 3600 | 1
392 | 82749102604 | 10000 | 1
393 | 82749104097 | 348 | 1
394 | 82749104097 | 380 | 1
395 | 82749105697 | 20000 | 99
396 | 82749105697 | 9792 | 99
397 | 82749106219 | 1081 | 99
398 | 82749106219 | 1081 | 99
399 | 82749106219 | 1081 | 99
400 | 82749106600 | 500 | 99
401 | 82749106600 | 1000 | 99
402 | 82749106600 | 9000 | 99
403 | 82749106600 | 9000 | 99
404 | 82749106898 | 12351 | 1
405 | 82749106898 | 160841 | 1
406 | 82750000097 | 488 | 10
407 | 82750000348 | 903 | 10
408 | 82750000364 | 298 | 10
409 | 82750000372 | 310 | 10
410 | 82750000402 | 240 | 10
411 | 82750000453 | 3194 | 10
412 | 82750000542 | 503 | 10
413 | 82750000810 | 751 | 10
414 | 82750000895 | 60 | 10
415 | 82750000925 | 300 | 10
416 | 82750000968 | 490 | 10
417 | 82750001093 | 290 | 10
418 | 82750001204 | 772 | 10
419 | 82750001271 | 700 | 10
420 | 82750001620 | 422 | 10
421 | 82750001654 | 1216 | 10
422 | 82750001662 | 207 | 10
423 | 82750001697 | 5495 | 10
424 | 82750001700 | 1194 | 10
425 | 82750001786 | 210 | 10
426 | 82750001808 | 1110 | 10
427 | 82750001859 | 1202 | 10
428 | 82750001867 | 30 | 10
429 | 82750001875 | 1570 | 10
430 | 82750001883 | 443 | 10
431 | 82750001999 | 300 | 10
432 | 82750002960 | 464 | 10
433 | 82750002979 | 330 | 10
434 | 82750002987 | 1116 | 10
435 | 82750003215 | 730 | 10
436 | 82750003223 | 510 | 10
437 | 82750003304 | 708 | 10
438 | 82750003339 | 30 | 10
439 | 82750003401 | 836 | 10
440 | 82750003622 | 600 | 10
441 | 82750003630 | 1526 | 10
442 | 82750003649 | 392 | 10
443 | 82750003665 | 1325 | 10
444 | 82750003886 | 723 | 10
445 | 82750003959 | 400 | 10
446 | 82750004017 | 2643 | 10
447 | 82750004041 | 326 | 10
448 | 82750004122 | 336 | 10
449 | 82750004130 | 250 | 10
450 | 82750004505 | 355 | 10
451 | 82750004521 | 190 | 10
452 | 82750004637 | 9990 | 10
453 | 82750004645 | 53 | 10
454 | 82750004670 | 223 | 10
455 | 82750004700 | 148 | 10
456 | 82750004823 | 453 | 10
457 | 82750004980 | 2735 | 10
458 | 82750005226 | 363 | 10
459 | 82750005250 | 31862 | 1
460 | 82750005250 | 31862 | 1
461 | 82750005269 | 25 | 1
462 | 82750005269 | 25 | 1
463 | 82750005315 | 800 | 10
464 | 82750005390 | 260 | 10
465 | 82750005412 | 594 | 10
466 | 82750005455 | 70 | 10
467 | 82750005463 | 400 | 10
468 | 82750005510 | 1535 | 10
469 | 82750100504 | 8020 | 10
470 | 82750100776 | 500 | 10
471 | 82750101152 | 75000 | 1
472 | 82750101152 | 203400 | 1
473 | 82750101292 | 297 | 10
474 | 82750101560 | 660 | 10
475 | 82750101756 | 470 | 10
476 | 82750101870 | 1637 | 10
477 | 82750102426 | 2473 | 10
478 | 82750102663 | 860 | 10
479 | 82750102701 | 200 | 99
480 | 82750102701 | 1 | 99
481 | 82750102736 | 390 | 10
482 | 82750102973 | 2923 | 10
483 | 82750103120 | 2378 | 10
484 | 82750103155 | 1388 | 10
485 | 82750103244 | 720 | 10
486 | 82750103406 | 9999 | 99
487 | 82750103406 | 114000 | 99
488 | 82750103570 | 1481 | 10
489 | 82750103597 | 290 | 10
490 | 82750104054 | 35 | 10
491 | 82750104372 | 563 | 10
492 | 82750104453 | 562 | 10
493 | 82750104585 | 693 | 10
494 | 82751100095 | 1500 | 1
495 | 82751100095 | 10000 | 1
496 | 82752100668 | 2140 | 1
497 | 82752100668 | 10000 | 1
498 | 82752101010 | 4000 | 12