Spreadsheet: 104652d1302177527-sumproduct-formula-help-copy-of-sample_nw
Sheet: List

Emp No | Department | Qualification | Grade | Basic
1 | Finance | University Degree | E | 1600
2 | Finance | University Degree | E | 1800
3 | Finance | University Degree | E | 1200
4 | Finance | University Degree | E | 1650
5 | Finance | Commercial Institute | E | 1400
6 | Finance | Commercial Institute | E | 1750
7 | Finance | BBA | M | 1800
8 | Finance | S.S.C. | M | 1100
9 | Finance | Graduate | M | 1350
 | Finance | BS Economics | M | 2200
 | Finance | Commercial Institute | M | 5500
10 | Finance | University Degree | M | 2500
11 | Finance | Master | S | 1850
12 | Finance |  | S | 1900
13 | Finance | Commercial Institute | S | 1100
14 | HR | University Degree | E | 1400
15 | HR | University Degree | E | 2200
198 | HR | Diploma | E | 2500
16 | HR | Master | E | 1750
17 | HR | Commercial Institute | E | 1750
18 | HR | University Degree | E | 1800
19 | HR | University Degree | E | 1450
20 | HR | University Degree | E | 1650
21 | HR | University Degree | E | 1600
22 | HR | University Degree | E | 2000
23 | HR | Diploma | E | 1885
24 | HR | Secondary | E | 1800
25 | HR | University Degree | E | 1760
26 | HR | University Degree | E | 1625
27 | HR | University Degree | E | 1905
28 | HR | University Degree | E | 1600
29 | HR | University Degree | E | 1900
30 | HR | University Degree | E | 1700
31 | HR | University Degree | E | 1325
32 | HR | BBA | E | 2000
33 | HR | Secondary | E | 1803
34 | HR | Graduate | M | 1572
35 | HR | Graduate | M | 1612
36 | HR | Graduate | M | 1636
37 | HR | Diploma | M | 1056
38 | HR | Graduate | M | 1858
39 | HR | Graduate | M | 1337
40 | HR | Graduate | M | 1495
41 | HR | Diploma | M | 1050
42 | HR | Graduate | M | 1210
43 | HR | Master | M | 1636
44 | HR | Graduate | M | 1394
45 | HR | S.S.C. | M | 1198
46 | HR | IBS Diploma | M | 1218
47 | HR | University Degree | M | 1765
48 | HR | University Degree | M | 1642
49 | HR | Secondary | M | 1400
50 | HR | Graduate | M | 1729
51 | HR |  | M | 1300
52 | HR | Graduate | M | 1424
53 | HR | Graduate | M | 1664
54 | HR | Graduate | M | 1700
55 | HR | Diploma | M | 1253
56 | HR | Commercial Institute | M | 1386
57 | HR | University Degree | M | 1757
58 | HR | S.S.C. | M | 1242
59 | HR | Diploma | M | 1631
60 | HR | Graduate | M | 1254
61 | HR | Graduate | M | 1290
62 | HR | University Degree | M | 1579
63 | HR | Graduate | M | 2100
64 | HR | Diploma | M | 1914
65 | HR | Master | M | 1221
66 | HR | BS Economics | M | 1830
67 | HR | University Degree | M | 2131
68 | HR | Graduate | M | 1784
69 | HR | Graduate | M | 1330
70 | HR | University Degree | M | 1647
71 | HR | University Degree | M | 1759
72 | HR | S.S.C. | M | 1559
73 | HR | S.S.C. | M | 1369
74 | HR | Graduate | M | 1670
75 | HR | Graduate | M | 1362
76 | HR | Graduate | M | 1254
77 | HR | University Degree | M | 1626
78 | HR | Master | M | 1570
79 | HR | University Degree | M | 1575
80 | HR | University Degree | M | 1549
81 | HR | University Degree | S | 2043
82 | HR | University Degree | S | 1159
83 | HR | University Degree | S | 1387
84 | HR | University Degree | S | 1766
85 | HR | Commercial Institute | S | 1400
86 | HR | Diploma | S | 1550
87 | HR | University Degree | S | 1605
88 | HR | Commercial Institute | S | 1720
89 | HR | University Degree | S | 2162
90 | HR | MBA | S | 1850
91 | HR | University Degree | S | 2000
92 | HR | University Degree | S | 1340
93 | HR | Secondary | S | 1628
94 | HR | Secondary | S | 1557
95 | HR | University Degree | S | 1632
96 | HR | University Degree | S | 1728
97 | HR | University Degree | S | 1876
98 | HR | University Degree | S | 1808
99 | HR | University Degree | S | 1725
100 | HR | High Education | S | 1550
101 | HR | Commercial Institute | S | 1773
102 | HR | Graduate | S | 1970
103 | Marketing | University Degree | E | 1475
104 | Marketing | Commercial Institute | E | 1825
105 | Marketing | University Degree | E | 1025
106 | Marketing | Secondary | E | 1343
107 | Marketing | Secondary | E | 1425
108 | Marketing | University Degree | E | 1030
109 | Marketing | Graduate | E | 1460
110 | Marketing | University Degree | E | 1790
111 | Marketing | University Degree | E | 1838
112 | Marketing | Graduate | E | 1840
113 | Marketing | BS Accounting | E | 1820
114 | Marketing | Graduate | E | 1950
115 | Marketing | MBA | E | 1710
116 | Marketing | Chartered Accountant | M | 1700
117 | Marketing | Graduate | M | 1189
118 | Marketing | University Degree | M | 1199
119 | Marketing | S.S.C. | M | 1244
120 | Marketing | S.S.C. | M | 1291
121 | Marketing | Graduate | M | 1335
122 | Marketing | Graduate | M | 1228
123 | Marketing | Master | M | 1500
124 | Marketing | High Education | M | 1554
125 | Marketing | Master | M | 1500
126 | Marketing | Graduate | M | 1297
127 | Marketing | University Degree | M | 1400
128 | Marketing | BS Accounting | M | 1600
129 | Marketing | University Degree | M | 1294
130 | Marketing | Graduate | M | 1516
131 | Marketing | University Degree | S | 2100
132 | Marketing | S.S.C. | S | 1654
133 | Marketing | Diploma | S | 1856
134 | Marketing | PhD | S | 1781
135 | Marketing | University Degree | S | 1800
136 | Marketing | University Degree | S | 1299
137 | Sales | University Degree | E | 1350
138 | Sales | Master | E | 1000
139 | Sales | BBA | E | 1750
140 | Sales | S.S.C. | M | 1500
141 | Sales |  | M | 1750
142 | Sales | University Degree | M | 1600
143 | Sales | Graduate | M | 1162
144 | Sales | University Degree | S | 1492
145 | Sales | University Degree | S | 1750
146 | Sales | University Degree | S | 1654
147 | Logistics | MBA | E | 1750
148 | Logistics | University Degree | E | 1526
149 | Logistics | Graduate | M | 1543
150 | Logistics | University Degree | S | 1704
151 | IT | University Student | E | 1875
152 | IT | Master | M | 1193
153 | IT | Graduate | M | 1365
154 | IT | Secondary | M | 1337
155 | IT | Chartered Accountant | M | 1575
156 | IT | Graduate | M | 1751
157 | IT | Chartered Accountant | M | 1365
158 | IT | Graduate | M | 1103
159 | IT | University Degree | S | 1802
160 | IT | MBA | S | 1848
161 | IT | Master | S | 1350
162 | IT | S.S.C. | S | 1450