Data
Merek Tipe Area Bulan Sum of Pen
Honda ###
Brio ###
Bandung ###
Jan ###
Feb ###
Jakarta ###
Jan ###
Feb ###
Surabaya ###
Jan ###
Feb ###
CRV ###
Bandung ###
Jan ###
Apr ###
Jakarta ###
Jan ###
Apr ###
Surabaya ###
Jan ###
Apr ###
Jazz ###
Bandung ###
Mar ###
Apr ###
Jakarta ###
Mar ###
Apr ###
Surabaya ###
Mar ###
Apr ###
Mitsubishi ###
Pajero ###
Bandung ###
Jan ###
Feb ###
Jakarta ###
Jan ###
Feb ###
Surabaya ###
Jan ###
Feb ###
Xpander ###
Bandung ###
Jan ###
Apr ###
Jakarta ###
Jan ###
Apr ###
Surabaya ###
Jan ###
Apr ###
Nissan ###
March ###
Bandung ###
Feb ###
Mar ###
Jakarta ###
Feb ###
Mar ###
Surabaya ###
Feb ###
Mar ###
Juke ###
Bandung ###
Mar ###
Apr ###
Jakarta ###
Mar ###
Apr ###
Surabaya ###
Mar ###
Apr ###
Suzuki ###
Ertiga ###
Bandung ###
Feb ###
Mar ###
Jakarta ###
Feb ###
Mar ###
Surabaya ###
Feb ###
Mar ###
Swift ###
Bandung ###
Mar ###
Apr ###
Jakarta ###
Mar ###
Apr ###
Surabaya ###
Mar ###
Apr ###
Toyota ###
Avanza ###
Bandung ###
Jan ###
Apr ###
Jakarta ###
Jan ###
Apr ###
Surabaya ###
Jan ###
Apr ###
Brio ###
Bandung ###
Jan ###
Feb ###
Jakarta ###
Jan ###
Feb ###
Surabaya ###
Jan ###
Feb ###
Land Cruiser ###
Bandung ###
Feb ###
Mar ###
Jakarta ###
Feb ###
Mar ###
Surabaya ###
Feb ###
Mar ###
(empty) ###
(empty) ###
(empty) ###
Total ###
Total Result ###
Sum of PPN 11%
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
Bulan Merek Code
Jan Toyota AVZ
Feb Toyota BRO
Mar Toyota LCR
Apr Honda JZZ
Apr Honda CRV
Jan Honda BRO
Feb Suzuki ETG
Mar Suzuki SWT
Jan Mitsubishi XPD
Feb Mitsubishi PJR
Mar Nissan MRC
Apr Nissan JKE
Apr Toyota AVZ
Jan Toyota BRO
Feb Toyota LCR
Mar Honda JZZ
Jan Honda CRV
Feb Honda BRO
Mar Suzuki ETG
Apr Suzuki SWT
Apr Mitsubishi XPD
Jan Mitsubishi PJR
Feb Nissan MRC
Mar Nissan JKE
Jan Toyota AVZ
Feb Toyota BRO
Mar Toyota LCR
Apr Honda JZZ
Apr Honda CRV
Jan Honda BRO
Feb Suzuki ETG
Mar Suzuki SWT
Jan Mitsubishi XPD
Feb Mitsubishi PJR
Mar Nissan MRC
Apr Nissan JKE
Apr Toyota AVZ
Jan Toyota BRO
Feb Toyota LCR
Mar Honda JZZ
Jan Honda CRV
Feb Honda BRO
Mar Suzuki ETG
Apr Suzuki SWT
Apr Mitsubishi XPD
Jan Mitsubishi PJR
Feb Nissan MRC
Mar Nissan JKE
Jan Toyota AVZ
Feb Toyota BRO
Mar Toyota LCR
Apr Honda JZZ
Apr Honda CRV
Jan Honda BRO
Feb Suzuki ETG
Mar Suzuki SWT
Jan Mitsubishi XPD
Feb Mitsubishi PJR
Mar Nissan MRC
Apr Nissan JKE
Apr Toyota AVZ
Jan Toyota BRO
Feb Toyota LCR
Mar Honda JZZ
Jan Honda CRV
Feb Honda BRO
Mar Suzuki ETG
Apr Suzuki SWT
Apr Mitsubishi XPD
Jan Mitsubishi PJR
Feb Nissan MRC
Mar Nissan JKE
Jan Toyota AVZ
Feb Toyota BRO
Mar Toyota LCR
Apr Honda JZZ
Apr Honda CRV
Jan Honda BRO
Feb Suzuki ETG
Mar Suzuki SWT
Jan Mitsubishi XPD
Feb Mitsubishi PJR
Mar Nissan MRC
Apr Nissan JKE
Apr Toyota AVZ
Jan Toyota BRO
Feb Toyota LCR
Mar Honda JZZ
Jan Honda CRV
Feb Honda BRO
Mar Suzuki ETG
Apr Suzuki SWT
Apr Mitsubishi XPD
Jan Mitsubishi PJR
Feb Nissan MRC
Mar Nissan JKE
Jan Toyota AVZ
Feb Toyota BRO
Mar Toyota LCR
Apr Honda JZZ
Apr Honda CRV
Jan Honda BRO
Feb Suzuki ETG
Mar Suzuki SWT
Jan Mitsubishi XPD
Feb Mitsubishi PJR
Mar Nissan MRC
Apr Nissan JKE
Total
Tipe Area Stok TerjuaPenjualan PPN
Avanza Jakarta 12 1488000000 11%
Brio Jakarta 12 1680000000 11%
Land Cruiser Jakarta 3 1254000000 11%
Jazz Jakarta 6 840000000 11%
CRV Jakarta 7 868000000 11%
Brio Jakarta 10 1500000000 11%
Ertiga Jakarta 10 1490000000 11%
Swift Jakarta 5 585000000 11%
Xpander Jakarta 11 1287000000 11%
Pajero Jakarta 5 715000000 11%
March Jakarta 6 708000000 11%
Juke Jakarta 6 798000000 11%
Avanza Jakarta 11 1342000000 11%
Brio Jakarta 12 1464000000 11%
Land Cruiser Jakarta 2 1595000000 11%
Jazz Jakarta 6 864000000 11%
CRV Jakarta 10 1270000000 11%
Brio Jakarta 8 832000000 11%
Ertiga Jakarta 7 721000000 11%
Swift Jakarta 9 927000000 11%
Xpander Jakarta 12 1608000000 11%
Pajero Jakarta 10 1420000000 11%
March Jakarta 9 1314000000 11%
Juke Jakarta 11 1573000000 11%
Avanza Jakarta 6 654000000 11%
Brio Jakarta 6 678000000 11%
Land Cruiser Jakarta 4 864000000 11%
Jazz Jakarta 5 655000000 11%
CRV Jakarta 7 777000000 11%
Brio Jakarta 6 798000000 11%
Ertiga Jakarta 7 917000000 11%
Swift Jakarta 6 834000000 11%
Xpander Jakarta 6 732000000 11%
Pajero Jakarta 5 730000000 11%
March Jakarta 7 966000000 11%
Juke Jakarta 6 786000000 11%
Avanza Bandung 6 834000000 11%
Brio Bandung 6 672000000 11%
Land Cruiser Bandung 8 960000000 11%
Jazz Bandung 9 1080000000 11%
CRV Bandung 11 1606000000 11%
Brio Bandung 12 1692000000 11%
Ertiga Bandung 6 780000000 11%
Swift Bandung 11 1507000000 11%
Xpander Bandung 7 854000000 11%
Pajero Bandung 10 1480000000 11%
March Bandung 9 1233000000 11%
Juke Bandung 12 1404000000 11%
Avanza Bandung 5 730000000 11%
Brio Bandung 7 980000000 11%
Land Cruiser Bandung 11 1375000000 11%
Jazz Bandung 10 1410000000 11%
CRV Bandung 10 1410000000 11%
Brio Bandung 6 858000000 11%
Ertiga Bandung 10 1220000000 11%
Swift Bandung 6 720000000 11%
Xpander Bandung 6 714000000 11%
Pajero Bandung 12 1584000000 11%
March Bandung 10 1440000000 11%
Juke Bandung 7 966000000 11%
Avanza Bandung 8 920000000 11%
Brio Bandung 12 1284000000 11%
Land Cruiser Bandung 9 1233000000 11%
Jazz Bandung 12 1728000000 11%
CRV Bandung 6 744000000 11%
Brio Bandung 5 720000000 11%
Ertiga Bandung 11 1529000000 11%
Swift Bandung 11 1441000000 11%
Xpander Bandung 6 828000000 11%
Pajero Bandung 11 1375000000 11%
March Bandung 5 510000000 11%
Juke Bandung 12 1728000000 11%
Avanza Surabaya 9 1323000000 11%
Brio Surabaya 12 1248000000 11%
Land Cruiser Surabaya 5 685000000 11%
Jazz Surabaya 5 540000000 11%
CRV Surabaya 5 655000000 11%
Brio Surabaya 8 968000000 11%
Ertiga Surabaya 7 882000000 11%
Swift Surabaya 5 745000000 11%
Xpander Surabaya 10 1100000000 11%
Pajero Surabaya 6 696000000 11%
March Surabaya 7 742000000 11%
Juke Surabaya 6 606000000 11%
Avanza Surabaya 10 1040000000 11%
Brio Surabaya 11 1386000000 11%
Land Cruiser Surabaya 11 1485000000 11%
Jazz Surabaya 6 750000000 11%
CRV Surabaya 11 1562000000 11%
Brio Surabaya 11 1386000000 11%
Ertiga Surabaya 11 1408000000 11%
Swift Surabaya 11 1441000000 11%
Xpander Surabaya 9 1161000000 11%
Pajero Surabaya 10 1460000000 11%
March Surabaya 10 1330000000 11%
Juke Surabaya 9 918000000 11%
Avanza Surabaya 5 730000000 11%
Brio Surabaya 11 1606000000 11%
Land Cruiser Surabaya 10 1260000000 11%
Jazz Surabaya 8 1048000000 11%
CRV Surabaya 6 714000000 11%
Brio Surabaya 6 774000000 11%
Ertiga Surabaya 8 1112000000 11%
Swift Surabaya 12 1644000000 11%
Xpander Surabaya 5 540000000 11%
Pajero Surabaya 9 1035000000 11%
March Surabaya 6 744000000 11%
Juke Surabaya 12 1320000000 11%
889 117127000000
PPN 11% Total Penjualan Tipe Mobil
1651680000 1,651,680,000.00 Code
1864800000 3,516,480,000.00 AVZ
1391940000 4,908,420,000.00 BRO
932400000 5,840,820,000.00 CRV
963480000 6,804,300,000.00 ETG
1665000000 8,469,300,000.00 IVA
1653900000 10,123,200,000.00 JZZ
649350000 10,772,550,000.00 JKE
1428570000 12,201,120,000.00 LCR
793650000 12,994,770,000.00 MRC
785880000 13,780,650,000.00 PJR
885780000 14,666,430,000.00 SWT
1489620000 16,156,050,000.00 XPD
1625040000 17,781,090,000.00
1770450000 19,551,540,000.00
959040000 20,510,580,000.00 Nb :
1409700000 21,920,280,000.00 1. Buat Sheet baru dengan
923520000 22,843,800,000.00 2. Rapikan dokumen yang s
800310000 23,644,110,000.00 3. Gunakan Rumus VLOOK
1028970000 24,673,080,000.00 4. Isi kolom yang berwarna
1784880000 26,457,960,000.00 5. Buat Report penjualan be
1576200000 28,034,160,000.00 6. Sheet 2 menggunakan R
1458540000 29,492,700,000.00
1746030000 31,238,730,000.00
725940000 31,964,670,000.00
752580000 32,717,250,000.00
959040000 33,676,290,000.00
727050000 34,403,340,000.00
862470000 35,265,810,000.00
885780000 36,151,590,000.00
1017870000 37,169,460,000.00
925740000 38,095,200,000.00
812520000 38,907,720,000.00
810300000 39,718,020,000.00
1072260000 40,790,280,000.00
872460000 41,662,740,000.00
925740000 42,588,480,000.00
745920000 43,334,400,000.00
1065600000 44,400,000,000.00
1198800000 45,598,800,000.00
1782660000 47,381,460,000.00
1878120000 49,259,580,000.00
865800000 50,125,380,000.00
1672770000 51,798,150,000.00
947940000 52,746,090,000.00
1642800000 54,388,890,000.00
1368630000 55,757,520,000.00
1558440000 57,315,960,000.00
810300000 58,126,260,000.00
1087800000 59,214,060,000.00
1526250000 60,740,310,000.00
1565100000 62,305,410,000.00
1565100000 63,870,510,000.00
952380000 64,822,890,000.00
1354200000 66,177,090,000.00
799200000 66,976,290,000.00
792540000 67,768,830,000.00
1758240000 69,527,070,000.00
1598400000 71,125,470,000.00
1072260000 72,197,730,000.00
1021200000 73,218,930,000.00
1425240000 74,644,170,000.00
1368630000 76,012,800,000.00
1918080000 77,930,880,000.00
825840000 78,756,720,000.00
799200000 79,555,920,000.00
1697190000 81,253,110,000.00
1599510000 82,852,620,000.00
919080000 83,771,700,000.00
1526250000 85,297,950,000.00
566100000 85,864,050,000.00
1918080000 87,782,130,000.00
1468530000 89,250,660,000.00
1385280000 90,635,940,000.00
760350000 91,396,290,000.00
599400000 91,995,690,000.00
727050000 92,722,740,000.00
1074480000 93,797,220,000.00
979020000 94,776,240,000.00
826950000 95,603,190,000.00
1221000000 96,824,190,000.00
772560000 97,596,750,000.00
823620000 98,420,370,000.00
672660000 99,093,030,000.00
1154400000 100,247,430,000.00
1538460000 101,785,890,000.00
1648350000 103,434,240,000.00
832500000 104,266,740,000.00
1733820000 106,000,560,000.00
1538460000 107,539,020,000.00
1562880000 109,101,900,000.00
1599510000 110,701,410,000.00
1288710000 111,990,120,000.00
1620600000 113,610,720,000.00
1476300000 115,087,020,000.00
1018980000 116,106,000,000.00
810300000 116,916,300,000.00
1782660000 118,698,960,000.00
1398600000 120,097,560,000.00
1163280000 121,260,840,000.00
792540000 122,053,380,000.00
859140000 122,912,520,000.00
1234320000 124,146,840,000.00
1824840000 125,971,680,000.00
599400000 126,571,080,000.00
1148850000 127,719,930,000.00
825840000 128,545,770,000.00
1465200000 130,010,970,000.00
130010970000 7,089,932,970,000.00
Nama
Avanza
Brio
CRV
Ertiga
Innova
Jazz
Juke
Land Cruiser
March
Pajero
Swift
Xpander
at Sheet baru dengan data yang sama dengan nama anda
pikan dokumen yang sedang dikerjakan
nakan Rumus VLOOKUP untuk isi data Tipe dari data Tipe Mobil
kolom yang berwarna jingga
at Report penjualan berdasarkan Merek dan Tipe di setiap wilayah menggunakan PIVOT
eet 2 menggunakan Rumus SUMIF untuk menentukan Jumlah penjualan semua Merek Setiap Bulan
Penjualan per All Merek
Bulan Penjualan PPN 12% Total
Jan
Feb
Mar
Apr
Bulan Merek Code
Jan Toyota AVZ
Feb Toyota BRO
Mar Toyota LCR
Apr Honda JZZ
Apr Honda CRV
Jan Honda BRO
Feb Suzuki ETG
Mar Suzuki SWT
Jan Mitsubishi XPD
Feb Mitsubishi PJR
Mar Nissan MRC
Apr Nissan JKE
Apr Toyota AVZ
Jan Toyota BRO
Feb Toyota LCR
Mar Honda JZZ
Jan Honda CRV
Feb Honda BRO
Mar Suzuki ETG
Apr Suzuki SWT
Apr Mitsubishi XPD
Jan Mitsubishi PJR
Feb Nissan MRC
Mar Nissan JKE
Jan Toyota AVZ
Feb Toyota BRO
Mar Toyota LCR
Apr Honda JZZ
Apr Honda CRV
Jan Honda BRO
Feb Suzuki ETG
Mar Suzuki SWT
Jan Mitsubishi XPD
Feb Mitsubishi PJR
Mar Nissan MRC
Apr Nissan JKE
Apr Toyota AVZ
Jan Toyota BRO
Feb Toyota LCR
Mar Honda JZZ
Jan Honda CRV
Feb Honda BRO
Mar Suzuki ETG
Apr Suzuki SWT
Apr Mitsubishi XPD
Jan Mitsubishi PJR
Feb Nissan MRC
Mar Nissan JKE
Jan Toyota AVZ
Feb Toyota BRO
Mar Toyota LCR
Apr Honda JZZ
Apr Honda CRV
Jan Honda BRO
Feb Suzuki ETG
Mar Suzuki SWT
Jan Mitsubishi XPD
Feb Mitsubishi PJR
Mar Nissan MRC
Apr Nissan JKE
Apr Toyota AVZ
Jan Toyota BRO
Feb Toyota LCR
Mar Honda JZZ
Jan Honda CRV
Feb Honda BRO
Mar Suzuki ETG
Apr Suzuki SWT
Apr Mitsubishi XPD
Jan Mitsubishi PJR
Feb Nissan MRC
Mar Nissan JKE
Jan Toyota AVZ
Feb Toyota BRO
Mar Toyota LCR
Apr Honda JZZ
Apr Honda CRV
Jan Honda BRO
Feb Suzuki ETG
Mar Suzuki SWT
Jan Mitsubishi XPD
Feb Mitsubishi PJR
Mar Nissan MRC
Apr Nissan JKE
Apr Toyota AVZ
Jan Toyota BRO
Feb Toyota LCR
Mar Honda JZZ
Jan Honda CRV
Feb Honda BRO
Mar Suzuki ETG
Apr Suzuki SWT
Apr Mitsubishi XPD
Jan Mitsubishi PJR
Feb Nissan MRC
Mar Nissan JKE
Jan Toyota AVZ
Feb Toyota BRO
Mar Toyota LCR
Apr Honda JZZ
Apr Honda CRV
Jan Honda BRO
Feb Suzuki ETG
Mar Suzuki SWT
Jan Mitsubishi XPD
Feb Mitsubishi PJR
Mar Nissan MRC
Apr Nissan JKE
Total
Penjualan per All Merek 12%
Bulan Penjualan PPN 12%
Jan 29919000000 33,509,280,000.00
Feb 29049000000 32,639,280,000.00
Mar 26913000000 30,503,280,000.00
Apr 29854000000 33,444,280,000.00
Tipe Area Stok TerjuaPenjualan PPN
Avanza Jakarta 12 1488000000 11%
Brio Jakarta 12 1680000000 11%
Land Cruiser Jakarta 3 1254000000 11%
Jazz Jakarta 6 840000000 11%
CRV Jakarta 7 868000000 11%
Brio Jakarta 10 1500000000 11%
Ertiga Jakarta 10 1490000000 11%
Swift Jakarta 5 585000000 11%
Xpander Jakarta 11 1287000000 11%
Pajero Jakarta 5 715000000 11%
March Jakarta 6 708000000 11%
Juke Jakarta 6 798000000 11%
Avanza Jakarta 11 1342000000 11%
Brio Jakarta 12 1464000000 11%
Land Cruiser Jakarta 2 1595000000 11%
Jazz Jakarta 6 864000000 11%
CRV Jakarta 10 1270000000 11%
Brio Jakarta 8 832000000 11%
Ertiga Jakarta 7 721000000 11%
Swift Jakarta 9 927000000 11%
Xpander Jakarta 12 1608000000 11%
Pajero Jakarta 10 1420000000 11%
March Jakarta 9 1314000000 11%
Juke Jakarta 11 1573000000 11%
Avanza Jakarta 6 654000000 11%
Brio Jakarta 6 678000000 11%
Land Cruiser Jakarta 4 864000000 11%
Jazz Jakarta 5 655000000 11%
CRV Jakarta 7 777000000 11%
Brio Jakarta 6 798000000 11%
Ertiga Jakarta 7 917000000 11%
Swift Jakarta 6 834000000 11%
Xpander Jakarta 6 732000000 11%
Pajero Jakarta 5 730000000 11%
March Jakarta 7 966000000 11%
Juke Jakarta 6 786000000 11%
Avanza Bandung 6 834000000 11%
Brio Bandung 6 672000000 11%
Land Cruiser Bandung 8 960000000 11%
Jazz Bandung 9 1080000000 11%
CRV Bandung 11 1606000000 11%
Brio Bandung 12 1692000000 11%
Ertiga Bandung 6 780000000 11%
Swift Bandung 11 1507000000 11%
Xpander Bandung 7 854000000 11%
Pajero Bandung 10 1480000000 11%
March Bandung 9 1233000000 11%
Juke Bandung 12 1404000000 11%
Avanza Bandung 5 730000000 11%
Brio Bandung 7 980000000 11%
Land Cruiser Bandung 11 1375000000 11%
Jazz Bandung 10 1410000000 11%
CRV Bandung 10 1410000000 11%
Brio Bandung 6 858000000 11%
Ertiga Bandung 10 1220000000 11%
Swift Bandung 6 720000000 11%
Xpander Bandung 6 714000000 11%
Pajero Bandung 12 1584000000 11%
March Bandung 10 1440000000 11%
Juke Bandung 7 966000000 11%
Avanza Bandung 8 920000000 11%
Brio Bandung 12 1284000000 11%
Land Cruiser Bandung 9 1233000000 11%
Jazz Bandung 12 1728000000 11%
CRV Bandung 6 744000000 11%
Brio Bandung 5 720000000 11%
Ertiga Bandung 11 1529000000 11%
Swift Bandung 11 1441000000 11%
Xpander Bandung 6 828000000 11%
Pajero Bandung 11 1375000000 11%
March Bandung 5 510000000 11%
Juke Bandung 12 1728000000 11%
Avanza Surabaya 9 1323000000 11%
Brio Surabaya 12 1248000000 11%
Land Cruiser Surabaya 5 685000000 11%
Jazz Surabaya 5 540000000 11%
CRV Surabaya 5 655000000 11%
Brio Surabaya 8 968000000 11%
Ertiga Surabaya 7 882000000 11%
Swift Surabaya 5 745000000 11%
Xpander Surabaya 10 1100000000 11%
Pajero Surabaya 6 696000000 11%
March Surabaya 7 742000000 11%
Juke Surabaya 6 606000000 11%
Avanza Surabaya 10 1040000000 11%
Brio Surabaya 11 1386000000 11%
Land Cruiser Surabaya 11 1485000000 11%
Jazz Surabaya 6 750000000 11%
CRV Surabaya 11 1562000000 11%
Brio Surabaya 11 1386000000 11%
Ertiga Surabaya 11 1408000000 11%
Swift Surabaya 11 1441000000 11%
Xpander Surabaya 9 1161000000 11%
Pajero Surabaya 10 1460000000 11%
March Surabaya 10 1330000000 11%
Juke Surabaya 9 918000000 11%
Avanza Surabaya 5 730000000 11%
Brio Surabaya 11 1606000000 11%
Land Cruiser Surabaya 10 1260000000 11%
Jazz Surabaya 8 1048000000 11%
CRV Surabaya 6 714000000 11%
Brio Surabaya 6 774000000 11%
Ertiga Surabaya 8 1112000000 11%
Swift Surabaya 12 1644000000 11%
Xpander Surabaya 5 540000000 11%
Pajero Surabaya 9 1035000000 11%
March Surabaya 6 744000000 11%
Juke Surabaya 12 1320000000 11%
Total
63,428,280,000.00
61,688,280,000.00
57,416,280,000.00
63,298,280,000.00
PPN 11% Total Penjualan Tipe Mobil
1651680000 1,651,680,000.00 Code
1864800000 3,516,480,000.00 AVZ
1391940000 4,908,420,000.00 BRO
932400000 5,840,820,000.00 CRV
963480000 6,804,300,000.00 ETG
1665000000 8,469,300,000.00 IVA
1653900000 10,123,200,000.00 JZZ
649350000 10,772,550,000.00 JKE
1428570000 12,201,120,000.00 LCR
793650000 12,994,770,000.00 MRC
785880000 13,780,650,000.00 PJR
885780000 14,666,430,000.00 SWT
1489620000 16,156,050,000.00 XPD
1625040000 17,781,090,000.00
1770450000 19,551,540,000.00
959040000 20,510,580,000.00 Nb :
1409700000 21,920,280,000.00 1. Buat Sheet baru denga
923520000 22,843,800,000.00 2. Rapikan dokumen yang
800310000 23,644,110,000.00 3. Gunakan Rumus VLOO
1028970000 24,673,080,000.00 4. Isi kolom yang berwarn
1784880000 26,457,960,000.00 5. Buat Report penjualan
1576200000 28,034,160,000.00 6. Sheet 2 menggunakan
1458540000 29,492,700,000.00
1746030000 31,238,730,000.00
725940000 31,964,670,000.00
752580000 32,717,250,000.00
959040000 33,676,290,000.00
727050000 34,403,340,000.00
862470000 35,265,810,000.00
885780000 36,151,590,000.00
1017870000 37,169,460,000.00
925740000 38,095,200,000.00
812520000 38,907,720,000.00
810300000 39,718,020,000.00
1072260000 40,790,280,000.00
872460000 41,662,740,000.00
925740000 42,588,480,000.00
745920000 43,334,400,000.00
1065600000 44,400,000,000.00
1198800000 45,598,800,000.00
1782660000 47,381,460,000.00
1878120000 49,259,580,000.00
865800000 50,125,380,000.00
1672770000 51,798,150,000.00
947940000 52,746,090,000.00
1642800000 54,388,890,000.00
1368630000 55,757,520,000.00
1558440000 57,315,960,000.00
810300000 58,126,260,000.00
1087800000 59,214,060,000.00
1526250000 60,740,310,000.00
1565100000 62,305,410,000.00
1565100000 63,870,510,000.00
952380000 64,822,890,000.00
1354200000 66,177,090,000.00
799200000 66,976,290,000.00
792540000 67,768,830,000.00
1758240000 69,527,070,000.00
1598400000 71,125,470,000.00
1072260000 72,197,730,000.00
1021200000 73,218,930,000.00
1425240000 74,644,170,000.00
1368630000 76,012,800,000.00
1918080000 77,930,880,000.00
825840000 78,756,720,000.00
799200000 79,555,920,000.00
1697190000 81,253,110,000.00
1599510000 82,852,620,000.00
919080000 83,771,700,000.00
1526250000 85,297,950,000.00
566100000 85,864,050,000.00
1918080000 87,782,130,000.00
1468530000 89,250,660,000.00
1385280000 90,635,940,000.00
760350000 91,396,290,000.00
599400000 91,995,690,000.00
727050000 92,722,740,000.00
1074480000 93,797,220,000.00
979020000 94,776,240,000.00
826950000 95,603,190,000.00
1221000000 96,824,190,000.00
772560000 97,596,750,000.00
823620000 98,420,370,000.00
672660000 99,093,030,000.00
1154400000 100,247,430,000.00
1538460000 101,785,890,000.00
1648350000 103,434,240,000.00
832500000 104,266,740,000.00
1733820000 106,000,560,000.00
1538460000 107,539,020,000.00
1562880000 109,101,900,000.00
1599510000 110,701,410,000.00
1288710000 111,990,120,000.00
1620600000 113,610,720,000.00
1476300000 115,087,020,000.00
1018980000 116,106,000,000.00
810300000 116,916,300,000.00
1782660000 118,698,960,000.00
1398600000 120,097,560,000.00
1163280000 121,260,840,000.00
792540000 122,053,380,000.00
859140000 122,912,520,000.00
1234320000 124,146,840,000.00
1824840000 125,971,680,000.00
599400000 126,571,080,000.00
1148850000 127,719,930,000.00
825840000 128,545,770,000.00
1465200000 130,010,970,000.00
130,010,970,000.00 7,089,932,970,000.00
Nama
Avanza
Brio
CRV
Ertiga
Innova
Jazz
Juke
Land Cruiser
March
Pajero
Swift
Xpander
at Sheet baru dengan data yang sama dengan nama anda
pikan dokumen yang sedang dikerjakan
nakan Rumus VLOOKUP untuk isi data Tipe dari data Tipe Mobil
kolom yang berwarna jingga
at Report penjualan berdasarkan Merek dan Tipe di setiap wilayah menggunakan PIVOT
eet 2 menggunakan Rumus SUMIF untuk menentukan Jumlah penjualan semua Merek Setiap Bulan