Pembelajaran Sumif dan countif 8E.xlsx

	C	D	E	F	G	I	J
1
2
3	No	Tanggal	Desa	Kecamatan	Jumlah
4	1	19/04/2021	Giritengah	Borobudur	86,060,200
5	2	03/04/2021	Gulon	Salam	87,783,750	Kecamatan	Jumlah Pajak
6	3	01/12/2021	Jumoyo	Salam	96,490,956	Borobudur
7	4	05/03/2021	Mantingan	Salam	91,897,585	Salam
8	5	02/10/2021	Kalibening	Dukun	89,484,800	Dukun
9	6	15/03/2021	Keningar	Dukun	85,298,644	Muntilan
10	7	11/08/2021	Sriwedari	Muntilan	97,691,137	Ngluwar
11	8	02/09/2021	Giripurno	Borobudur	91,643,137
12	9	08/01/2021	Blongkeng	Ngluwar	91,361,153
13	10	21/11/2021	Ngluwar	Ngluwar	81,726,904	Kecamatan	Jumlah Desa
14	11	19/01/2021	Muntilan	Muntilan	97,040,412	Borobudur
15	12	09/09/2021	Keji	Muntilan	99,969,320	Salam
16	13	07/04/2021	Borobudur	Borobudur	86,861,908	Dukun
17	14	09/12/2021	Bumiharjo	Borobudur	92,552,126	Muntilan
18	15	20/09/2021	Banyudono	Dukun	85,226,916	Ngluwar
19	16	13/02/2021	Adikarto	Muntilan	94,480,726
20	17	27/05/2021	Gunungpring	Muntilan	90,191,601
21	18	09/03/2021	Salam	Salam	94,190,112
22	19	26/06/2021	Baturono	Salam	85,547,729
23	20	07/02/2021	Karangtalun	Ngluwar	98,160,323
24	21	01/12/2021	Congkrang	Muntilan	83,704,459
25	22	19/01/2021	Sedayu	Muntilan	88,599,687
26	23	05/01/2021	Ngawen	Muntilan	90,360,329
27	24	27/06/2021	Bigaran	Borobudur	84,336,508
28	25	06/05/2021	Banyubiru	Dukun	95,086,445
29	26	07/10/2021	Bligo	Ngluwar	86,236,798
30	27	22/05/2021	Jamuskauman	Ngluwar	89,706,960
31	28	03/05/2021	Gondosuli	Muntilan	80,931,886
32	29	22/08/2021	Menayu	Muntilan	80,570,054
33	30	27/08/2021	Pucungrejo	Muntilan	99,038,790
34	31	25/04/2021	Sokorini	Muntilan	94,013,105
35	32	03/12/2021	Tanjung	Muntilan	80,441,150
36	33	10/09/2021	Sawangan	Sawangan	87,911,547
37	34	23/03/2021	Banyuroto	Sawangan	95,664,283
38	35	07/05/2021	Butuh	Sawangan	96,934,264
39	36	12/01/2021	Gantang	Sawangan	91,974,800
40	37	17/04/2021	Tamanagung	Muntilan	80,132,820
41	38	26/02/2021	Candirejo	Borobudur	94,314,473
42	39	03/10/2021	Kadiluwih	Salam	88,263,309
43	40	04/10/2021	Dukun	Dukun	96,819,148
44	Jumlah Total Pajak
45	Jumlah Total Desa
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