extracción de datos según criterios de fecha.xlsx

249
Fechas Valores Fecha1 Fecha2 10/1/2001 3,307.00 10/1/2001 9/30/2002 10/2/2001 9,755.00 10/3/2001 7,841.00 10/4/2001 20,501.00 10/5/2001 1,491.00 10/6/2001 15,207.00 10/7/2001 11,097.00 10/8/2001 20,957.00 10/9/2001 13,410.00 10/10/2001 24,133.00 10/11/2001 4,657.00 10/12/2001 2,433.00 10/13/2001 19,744.00 10/14/2001 17,674.00 10/15/2001 12,633.00 10/16/2001 3,433.00 10/17/2001 23,743.00 10/18/2001 21,418.00 10/19/2001 22,425.00 10/20/2001 15,257.00 10/21/2001 3,158.00 10/22/2001 24,870.00 10/23/2001 4,414.00 10/24/2001 5,529.00 10/25/2001 23,807.00 10/26/2001 9,823.00 10/27/2001 6,403.00 10/28/2001 22,515.00 10/29/2001 16,460.00 10/30/2001 10,865.00 10/31/2001 13,389.00 11/1/2001 10,038.00 11/2/2001 20,879.00 11/3/2001 22,567.00 11/4/2001 15,866.00 11/5/2001 15,812.00 11/6/2001 19,292.00 11/7/2001 7,195.00 11/8/2001 3,249.00 11/9/2001 8,788.00 11/10/2001 23,922.00 11/11/2001 4,792.00 11/12/2001 16,699.00 11/13/2001 6,249.00

Upload: raul-cesena

Post on 05-Oct-2015

220 views

Category:

Documents


0 download

TRANSCRIPT

DatosFechasValoresFecha1Fecha2Valor10/1/013,307.0010/1/019/30/024,870,501.00=SUMAPRODUCTO(($A$2:$A$3653>=E2)*($A$2:$A$3653=E2)*($A$2:$A$3653=A2)*(Datos!$A$2:$A$3653=A2)*(Datos!$A$2:$A$3653