subtotales en excel

Upload: roockbert

Post on 02-Mar-2016

212 views

Category:

Documents


0 download

DESCRIPTION

Excel Avazando Subtotales_1Excel Avazando Subtotales_1Excel Avazando Subtotales_1Excel Avazando Subtotales_1Excel Avazando Subtotales_1Excel Avazando Subtotales_1Excel Avazando Subtotales_1Excel Avazando Subtotales_1Excel Avazando Subtotales_1

TRANSCRIPT

  • EMPRESA EMBOTELLADORA DEL NORTEVENTA DE PRODUCTOS

    PRODUCTO VENDEDOR FECHA VENTA CIUDAD SUCURSAL TOTAL VENTAS COMISION TOTAL COMISIONGUARANA ALONSO GONZALES 8/1/2014 PIURA B 5000 1.90% 30.78FANTA JESSICA TORRES 8/1/2014 TUMBES A 0.02 1.70% 25.84FANTA NESTOR RIOS 8/1/2014 TRUJILLO A 2540 2.10% 53.34FANTA OMAR VILLEGAS 8/1/2014 CHICLAYO A 2080 1.80% 37.44COCACOLA ROSARIO BENITES 8/1/2014 LIMA B 2142 2.00% 42.84SPRITE TERESA REYES 8/1/2014 CHIMBOTE C 2882 1.50% 43.23COCACOLA VANESSA PERALTA 8/1/2014 HUARAZ C 12 2.20% 27.26GUARANA ALONSO GONZALES 8/2/2014 TUMBES C 1476 1.70% 25.09SPRITE JESSICA TORRES 8/2/2014 CHICLAYO B 2926 1.80% 52.67COCACOLA NESTOR RIOS 8/2/2014 LIMA C 2814 2.00% 56.28FANTA OMAR VILLEGAS 8/2/2014 CHIMBOTE A 2980 1.50% 44.70FANTA ROSARIO BENITES 8/2/2014 HUARAZ B 2520 2.20% 55.44SPRITE TERESA REYES 8/2/2014 TRUJILLO A 1320 2.10% 27.72COCACOLA VANESSA PERALTA 8/2/2014 PIURA B 2247 1.90% 42.69COCACOLA ALONSO GONZALES 8/3/2014 CHICLAYO A 1701 1.80% 30.62SPRITE JESSICA TORRES 8/3/2014 LIMA A 2662 2.00% 53.24FANTA NESTOR RIOS 8/3/2014 PIURA A 1500 1.90% 28.50GUARANA OMAR VILLEGAS 8/3/2014 HUARAZ B 1908 2.20% 41.98COCACOLA ROSARIO BENITES 8/3/2014 TUMBES C 1365 1.70% 23.21SPRITE TERESA REYES 8/3/2014 HUARAZ B 1672 2.20% 36.78GUARANA VANESSA PERALTA 8/3/2014 TRUJILLO C 918 2.10% 19.28COCACOLA ALONSO GONZALES 8/4/2014 LIMA B 2772 2.00% 55.44FANTA JESSICA TORRES 8/4/2014 CHIMBOTE B 2700 1.50% 40.50SPRITE NESTOR RIOS 8/4/2014 CHICLAYO C 2508 1.80% 45.14GUARANA OMAR VILLEGAS 8/4/2014 LIMA C 2070 2.00% 41.40FANTA ROSARIO BENITES 8/4/2014 TRUJILLO A 1420 2.10% 29.82COCACOLA TERESA REYES 8/4/2014 PIURA A 1155 1.90% 21.95FANTA VANESSA PERALTA 8/4/2014 TUMBES A 1860 1.70% 31.62GUARANA ALONSO GONZALES 8/5/2014 TRUJILLO A 2106 2.10% 44.23FANTA JESSICA TORRES 8/5/2014 HUARAZ C 2960 2.20% 65.12COCACOLA NESTOR RIOS 8/5/2014 CHIMBOTE B 1974 1.50% 29.61SPRITE OMAR VILLEGAS 8/5/2014 PIURA B 2662 1.90% 50.58SPRITE ROSARIO BENITES 8/5/2014 PIURA C 2860 1.90% 54.34GUARANA TERESA REYES 8/5/2014 LIMA A 1548 2.00% 30.96SPRITE VANESSA PERALTA 8/5/2014 CHICLAYO A 1386 1.80% 24.95FANTA ALONSO GONZALES 8/6/2014 HUARAZ C 1340 2.20% 29.48FANTA JESSICA TORRES 8/6/2014 PIURA B 1520 1.90% 28.88FANTA NESTOR RIOS 8/6/2014 HUARAZ A 2040 2.20% 44.88SPRITE OMAR VILLEGAS 8/6/2014 TRUJILLO C 2398 2.10% 50.36COCACOLA ROSARIO BENITES 8/6/2014 CHIMBOTE A 1428 1.50% 21.42GUARANA TERESA REYES 8/6/2014 CHICLAYO A 1134 1.80% 20.41

  • GUARANA VANESSA PERALTA 8/6/2014 CHIMBOTE A 1530 1.50% 22.95COCACOLA ALONSO GONZALES 8/7/2014 CHIMBOTE C 2040 1.50% 30.60SPRITE JESSICA TORRES 8/7/2014 TRUJILLO B 2772 2.10% 58.21GUARANA NESTOR RIOS 8/7/2014 TUMBES A 2700 1.70% 45.90FANTA OMAR VILLEGAS 8/7/2014 TUMBES C 2882 1.70% 48.99FANTA ROSARIO BENITES 8/7/2014 CHICLAYO A 1869 1.80% 33.64COCACOLA TERESA REYES 8/7/2014 TUMBES A 1026 1.70% 17.44SPRITE VANESSA PERALTA 8/7/2014 LIMA A 1716 2.00% 34.32

    Hoja1