M

NAMES ADDRESS
TOWN/CITY PROVINCE JUNE
Buensalida, Jericho Joseph P. b1 SPC LAGUNA 323
Cacao, Jose Pascual Seatiel Fajardo b2 TIAONG QUEZON 450
Castillo, Russel Riesgo b3 TALISAY QUEZON 344
Chumacera, John Karlo Chavenia b4 STO TOMAS BATANGAS 233
Kato, Masaru Urriza b5 SPC LAGUNA 290
Ortiz, Lance Ulysses De la Cruz b6 SPC LAGUNA 488
Prudente, Virgilio Joaquin III b7 NAGCARLAN LAGUNA 500
Sevilla, John Riz Carreon b8 NAGCARLAN LAGUNA 389
 MONTHLY SAVINGS

JULY AUGUSTSEPTEMBER
OCTOBERNOVEMBER
DECEMBER TOTAL (SUM)
344 455 500 444 100 2166
280 200 500 500 250 2180
100 100 120 150 250 1064
210 450 400 300 380 350 2323
500 500 100 100 100 120 1710
500 250 320 389 480 470 2897
250 500 280 345 500 2375
230 500 500 333 435 450 2837

VLOOKUP w/ DRO
NAME
b5
`

SUMIF
PROVINCE
LAGUNA
 BASIC FORMULAS @ EXCEL
AVE COUNT CONCATENATE
361 6 SPC, LAGUNA
363.333333333333 6 TIAONG, QUEZON
177.333333333333 6 TALISAY, QUEZON
331.857142857143 7 STO TOMAS, BATANG
244.285714285714 7 SPC, LAGUNA
413.857142857143 7 SPC, LAGUNA
395.833333333333 6 NAGCARLAN, LAGUN
405.285714285714 7 NAGCARLAN, LAGUN

VLOOKUP w/ DROPDOWN LIST

SUMIF
TOTAL SAVINGS
1990
 IF COUNTIF
VERY GOOD 1
VERY GOOD 2
SAVE MORE 0
VERY GOOD 0
SAVE MORE 2
VERY GOOD 1
VERY GOOD 3
VERY GOOD 2
 ANNUAL SALES
ITEM JANUARYFEBRUARMARCH APRIL MAY JUNE JULY
KEYBOAR 87965 87464 46598 23513 52413 53263 12454
MOUSE 46598 13434 98659 12435 12476 13546 134674
UPS 98659 12364 46598 14889 31346 45878 13445
MONITOR 46598 52434 53263 44344 56421 54685 124998
EARPHON 53263 52413 13546 21134 12487 89567 13499
SPEAKER 31223 12476 45878 13499 14346 5689 68986
LAN CAB 23512 31346 54685 68986 54154 52235 48956
RJ45 13111 56421 46581 48956 6656 2365 4658
WIFI ROU 99988 12487 46543 56585 46548 46499 55685
ALES
AUGUST SEPTEMBOCTOBENOVEMBDECEMBER
132521 12456 53263 124514 124543
132246 13499 13546 12154 134466
46246 68986 45878 13411 455642
25465 48956 54685 12155 124343
53263 11454 46598 13499 12564
13546 89659 5655 68986 12464
45878 5685 565626 48956 159554
54685 52655 5648 64165 795876
4151 265568 26564 46641 465464
 Male Female
1 Alcantara, Jyrille Rances 1 Arceta, Eleina Marideth Ortega
2 Arcedera, Dave Grohl Zephyr Enrile 2 Arellano, Kristine Joy Banzuela
3 Bondad, Marlon II Ladanga 3 Arias, Gilliane Escueta
4 Concordia, Irone Bernardino 4 Arjona, Kristina Camille Angeles
5 Coronado, Gieo Pisano 5 Averion, Joannarose Magno
6 De Alday, Mathew Irvin Santillan 6 Bañagale, Bea Alyanna Alvaran
7 Donor, Dane Marionne Piñana 7 Borja, Suzanne Gabrielle San Juan
8 Dulay, Cris Nathaniel Tolentino 8 Carandang, Yssah Gabrielle Pabellosa
9 Ferrer, Daniel Vincent Balanial 9 Catapang, Charisse Hernandez
10 Flores, Marc Revzen Bonilla 10 Ciar, Caryn Vernice Devilla
11 Gapangada, Marc Arnel Ela, 11 De Luna, Edelisha Beth Delos Reyes
12 Garcia, Nikierson Pulgado 12 Denuna, Lalaine Mendoza
13 Joaquin, Carl Jharvey VIII Lanzuela 13 Derequito, Camille Joy Atillo
14 Matuto, Paul Aaron Siazon 14 Duque, Katrina Kate Punzalan
15 Montañano, Drix Clairone Isleta 15 Gregana, Trisha Marie Fajardo
16 Parato, Jerome Patrick Ilarde 16 Juaneza, Lucy Marie Alexa Larona
17 Perez, Mark Jearoll Cachuela 17 Kalaw, Ma. Elyzee Verna Celis
18 Pesigan, Ronaldo Gastilo 18 Medina, April Jhayne Mendoza
19 Tuazon, Giann Angelo Tolentino 19 Mitra, Czarina D.,
20 Vista, Timothy Zymoune Averion 20 Pandiño, Zhairene -
21 Polborido, Catherine Eveth Bobis
22 Ricamara, Penelope Kate Sadia
23 Velasco, Angela Benabise
24 Villanueva, Hannah Maye Abril
25 Ville, Marquise Jewelle Rivera
 Male Female
1 Banzuela, Remmus Roi Latayan 1 Aguason, Trizha Mei Azusano
2 Belarmino, Bjorn Gavin Alcantara 2 Aliazas, Liezel Andrea Panaligan
3 Caponpon, Daryll Dan Catapang 3 Asuncion, Jaycierrel Fiona Flores
4 Carandang, John Paul Capiña 4 Avenido, Charlize Andrea Dejelo
5 Culaban, Raymond Joseph Fule 5 Balitaan, Katleya Andrea Acero
6 De Gala, Jervin Marcaux Guisando 6 Bolaño, Krizzia Pauline Andal
7 Enriquez, Miguel Sebastien Salvador 7 Brillantes, Reese Almanza
8 Evasco, Jim Broderick Novenario 8 Bulatao, Kianne Robin Cordova
9 Exconde, Mark Jeuz Caponpon 9 Carandang, Frances Rianna Josephine Dungca
10 Fajardo, Albert Joseph Ronquillo 10 Concordia, Franzine Alec Adres
11 Gapas, Jenrick Ivan Ramos 11 Cueto, Erika Sabuco
12 Guevarra, Frank Anthony Bartolome 12 De Los Reyes, Ernaliz Kaye Banca
13 Lucero, Jairus Jake Malelang 13 Dioso, Ellaine Ramos
14 Madriaga, Lemuel Capuno 14 Hernandez, Kate Ferlienor Sablan
15 Mantilla, Steven Kim Manto 15 Ilagan, Faith Joy Paganaman
16 Novelo, Aljon Antenor 16 Kamatoy, Riana Gaebrielle Belen
17 Punzalan, Renz Samonte 17 Magsambol, Angel Austria
18 Secreto, Jesster Val Sy 18 Maloles, Ericka Olgado
19 Valencia, John Reigh Nañuz 19 Mojado, Katrina Cuento
20 Villanueva, Gabriel Avanzado 20 Moreno, Angela Flores
21 Perado, Jhowee Aira Ramos
22 Ramos, Charydan Dorado
23 Ticzon, Anna Abigail Belda
24 Velasco, Maria Jo-Anne Endaya
25 Villegas, Joanna Micah Recto
 Male Female
1 Ancaja, John RJ Barleta 1 Arroyo, Rishcia Paye Capuno
2 Arevalo, Christian Justine Barcenas 2 Asegurado, Kaye Hannah Sombilla
3 Brul, Brian Vincent Janabajal 3 Belen, Kayezel Sabas
4 Cornista, Luigi Martin Rivera 4 Bicomong, Lovely Janine Guinto
5 De la Cruz, Michael Elisha Ferrer 5 Capuno, Alliah Torres
6 Dimatatac, Kyell Punay 6 Chavez, Aryanna Maree Barreto
7 Enrile, Jouie Lee Briones 7 Cipres, Regine Flores
8 Fabro, Gaeus Caskie Alles 8 Collera, Patricia Rose Sinen
9 Garduce, Joseph Dave Aldovino 9 Cosico, Stephanie Maris Quizon
10 Go, Kenneth Alfred Magpantay 10 Coyoca, Jemiah -
11 Gonzales, Andre Reyes 11 Derequito, Jhasirey Kim Frances Caneo
12 Lara, Rederick Justin De Luna 12 Deveza, Jarian Erjah Como
13 Marcelo, Jan Michael Vincent Solis 13 Durano, Rone Ana Bernabe
14 Musico, Nick Emmanuel Guibone 14 Ecol, Janna Marieglo Alvarez
15 Pasco, Symon Joshua Yaun 15 Espinosa, Nikka Viterbo
16 Prado, Joshua Paolo Bicomong 16 Guba, Aira Joy Gapunay
17 Reyes, Carlo James Librada 17 Iglesias, Shane Emmanuelle Deangkinay
18 Selma, Adrielle Loreto 18 Lucido, Hannah Idabell Vista
19 Valdez, Fryan Auric Luanzon 19 Meraña, Ylaine Aquino
20 Monecia, Franzcene Kline Alejandro
21 Octavio, Princess Glyzel Limbo
22 Sahagun, Daniela Veñegas
23 Sandoval, Marielle Umali
24 So, Joan Bernadette Cadeliña
25 Ugat, Ira Marie Diana
26 Verzosa, Nina Ariellei Briton
 Male Female
1 Alvarez, Pablo Jose Nuevo 1 Alcayde, Krisha Mara Deyto
2 Belen, Kyle Fandialan 2 Almirañez, Trisha Vannery Escovilla
3 Carpio, Leander Matthew Garcia 3 Aranguren, Faith Carminna Maglaque
4 Decano, Vince Nathaniel Familiar 4 Arenas, Sophia Mei Suministrado
5 Devanadera, John Paul De Villa 5 Atienza, Patricia Anne Ramirez
6 Eneria, Stephen Gabriel Prodigalidad 6 Balasoto, Mikaela Denise Balderama
7 Federizo, Allen Kim Muñoz 7 Balmes, Maria Ravelyn Tiapson
8 Isles, Marc William Dorado 8 Belen, Maria Febe Dayo
9 Luha, Jericho Lacsina 9 Cacao, Maria Alexandra -
10 Maneclang, Jared Aguilar 10 Castillo, Keisha Paulene Magsino
11 Matabang, Justine Coronado 11 Castillo, Tielsy Roallos
12 Mendoza, Nicko Porcalla 12 Colares, Aleiza Nadine Bagaporo
13 Moreno, Alain Micko Calalo 13 Cortez, Nina Kyrelle Benedictos
14 Paje, Joshua Pierre Don 14 Dantic, Blu Ann Margaret Garcia
15 Paliza, Carl Jayron Martinez 15 Ebreo, Victoriana Loraine Sulit
16 Reyes, Lance Emiel Deriquito 16 Garcia, Marie Margaret Sophia Danila
17 Salcedo, Jemuel Rapa 17 La Valle, Jan Vincentte Capistrano
18 Sinen, Nikolai Alejandre Federis 18 Mago, Lean Caila Ogalin
19 Velasco, Rancee Tubigan 19 Montecillo, Deniella Denise Sobreviñas
20 20 Opulencia, Lara Jemimah Dela Mar
21 Perona, Jianyca Marquez
22 Pujeda, Janna Tricia Capilit
23 Pumar, Althea Grace Mojica
24 Romanes, Pauline Borgoños
25 Sañado, Jel Auverry Camposano
26 Wilcken, Audrey Briguela
 Male Female
1 Abastas, John Simmon - 1 Agra, Ma. Michaela Anjeline Almario
2 Albia, Paul Niño Elesterio 2 Aquilo, Christine Basilio
3 Aramil, Geoffrey Miles Abapo 3 Arceo, Bernadeth Alidio
4 Bautista, Carlfrance Jaycee Aragones 4 Arcilla, Meljoy Delfino
5 Bisnar, Erick John Gesmundo 5 Ardeza, Hannah Arabe
6 Catapang, John Lloyd Historillo 6 Austria, Veinna Denice Austria
7 Catipon, John Bernard Villabroza 7 Avenido, Cheska Andrea Cabantog
8 Consignado, Neil Francis Manipol 8 Bicomong, Cielo Bonilla
9 Dionglay, Jeuz Andre Belen 9 Bulanhagui, Frances Amanda Pisano
10 Enriquez, Brylle Hermoso 10 Caparas, Phoebe May Almoza
11 Fernandez, Ciane Aynsley Telleran 11 Capistrano, Patricia Capiña
12 Javier, Aldrich Palla 12 Cayube, Adriana Emery Escueta
13 Manalo, Mart Justine - 13 Cubilla, Christine Gapunay
14 Marcial, Andrei Jed Cabillan 14 Datinginoo, Maria Mikaela -
15 Orola, Christian Bautista 15 Delos Santos, Katherine Fandialian
16 Orolfo, Angelo Alad 16 Durano, Rone Ana Bernabe
17 Panopio, Clarence Bienvenida 17 Glorioso, Jasmine Nichole Navarro
18 Ramos, Jhon Mathew Gari 18 Gorom, Julian Nicole Azucena
19 Sola, Sieg Gabriel Grantoza, 19 Lumbera, Ariane Velasco
20 Toledo, Asher Bicomong 20 Magcase, Althea Mari Valderama
21 Manlapaz, Sharmaine Harabe
22 Perillo, Kyla Beatrice Torres
23 Sabal, Anika Doriethy Chua
24 Tiongco, Franchesca Julliana Mhay Castillo
25 Trinidad, Abi Katrina Ariana Cosico
26 Velasquez, Mary Jeane Reyes