Copy of Copy of Sumifs Function

	A	B	C	D	E	F	I	J	K
1	S.NO	Employee Code	Name	Designation	Transaction Type	Salary
2	1	Emp 1	Amit	Sales Manager	Debit Card	44095
3	2	Emp 2	Ajay	HR	Debit Card	38526
4	3	Emp 3	Karan	MIS Excutive	Debit Card	64880
5	4	Emp 4	Vivek	Civil Engineer	Cash	56210
6	5	Emp 5	Sachin	MIS Excutive	Online	46619
7	6	Emp 6	Mukul	Sales Manager	Debit Card	50534
8	7	Emp 7	Jatin	Civil Engineer	Debit Card	67230
9	8	Emp 8	Akhil	MIS Excutive	Debit Card	47354	Sumifs
10	9	Emp 9	Annu	Sales Manager	Cash	60413	Designation	Civil Engineer	99858
11	10	Emp 10	Komal	MIS Excutive	Online	56757	Transaction Type	Online	99858
12	11	Emp 11	Himanshu	HR	Debit Card	62980
13	12	Emp 12	Pawan	Civil Engineer	Online	54471
14	13	Emp 13	Prem	Sales Manager	Online	39338
15	14	Emp 14	Nitish	Sales Manager	Cash	60164
16	15	Emp 15	Yogesh	Civil Engineer	Debit Card	64842	Sumifs
17	16	Emp 16	Neeraj	HR	Cash	59004	Designation	Civil Engineer
18	17	Emp 17	Devraj	Sales Manager	Debit Card	67575	Transaction Type	Online
19	18	Emp 18	Kishan	HR	Cash	41463
20	19	Emp 19	Kuldeep	Sales Manager	Cash	36651
21	20	Emp 20	Sahil	HR	Online	46623
22	21	Emp 21	Nidhi	Sales Manager	Cash	41791
23	22	Emp 22	Chhaya	Sales Manager	Online	55920
24	23	Emp 23	Taniya	MIS Cordinator	Online	60838
25	24	Emp 24	Sanjay	HR	Debit Card	38002
26	25	Emp 25	Diwakar	HR	Debit Card	59009
27	26	Emp 26	Mahesh	Civil Engineer	Online	45387
28	27	Emp 27	Neelam	Civil Engineer	Cash	52882
29	28	Emp 28	Sunil	MIS Excutive	Cash	51656
30	29	Emp 29	Ravi	Sales Manager	Online	45819
31	30	Emp 30	Salman	MIS Excutive	Debit Card	65715
32	31	Emp 31	Rajan	Civil Engineer	Debit Card	45905
33	32	Emp 32	Arjun	Sales Manager	Cash	43582
34	33	Emp 33	Ankur	Civil Engineer	Cash	37914
35	34	Emp 34	Anil	MIS Cordinator	Online	60804
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100