SUMAR.SI por el mes de una fecha ???

Printable View

May 30th, 2002, 08:38 AM
luis romero

Buen dia amigos,

En la columna A tengo fechas y en la B tengo importes. en otro lado tengo meses. como podria hacerle para que me sume importes por cada mes respectivo?, he intentado la sig formula pero no me funciona:

=SUMAR.SI(fechas,mes(fechas)=1,importes)

fechas es el rango de las fechas de movimiento, Importes es el rango a sumar

De antemano, gracias por sus aportaciones.

Luis Romero
May 30th, 2002, 03:19 PM
Renzo G

Luis,

Lo que puedes hacer es crear una columna extra "C" donde colocas la formula mes (que te devolvera un numero del 1 al doce), a continuacion en la cuarta columna colocas verticalmente una numeracion del 1 al 12. la formula que deberias usar seria la siguiente:

SUMAR.SI($C$2:$C$30,D$1,$B$2:$B$21)

Saludos,

Renzo
May 30th, 2002, 03:44 PM
Juan Pablo González

Algo así sirve ?

<CENTER><TABLE align=center border=1 borderColor=#c0c0c0 cellSpacing=0 width="60%"><TBODY><TR><TD bgColor=#0c266b colSpan=6><TABLE align=center border=0 width="100%"><TBODY><TR><TD align=left>Microsoft Excel - Libro1</TD><TD align=right>___Running: xl2000 : OS = Windows NT4.0</TD></TR></TBODY></TABLE></TD></TR><TR><TD bgColor=#d4d0c8 colSpan=6><TABLE align=center border=0 height=10 width="100%" VALIGN="MIDDLE"><TBODY><TR><TD>(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp</TD><TD align=right vAlign=center><FORM name=formCb117><INPUT name=btCb339 *******='window.clipboardData.setData("Text",document.formFb202.sltNb942.value);' type=button value="Copy Formula"></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD bgColor=white colSpan=6><TABLE border=0><TBODY><TR><FORM name=formFb202><TD align=middle bgColor=white width="5%"><SELECT name=sltNb942 onchange="document.formFb202.txbFb116.value = document.formFb202.sltNb942.value"><OPTION value==SUMAPRODUCTO((MES($A$2:$A$23)=D2)*$B$2:$B$23)>E2<OPTION value==SUMAPRODUCTO((MES($A$2:$A$23)=D3)*$B$2:$B$23)>E3<OPTION value==SUMAPRODUCTO((MES($A$2:$A$23)=D4)*$B$2:$B$23)>E4<OPTION value==SUMAPRODUCTO((MES($A$2:$A$23)=D5)*$B$2:$B$23)>E5<OPTION value==SUMAPRODUCTO((MES($A$2:$A$23)=D6)*$B$2:$B$23)>E6<OPTION value==SUMAPRODUCTO((MES($A$2:$A$23)=D7)*$B$2:$B$23)>E7<OPTION value==SUMAPRODUCTO((MES($A$2:$A$23)=D8)*$B$2:$B$23)>E8<OPTION selected value==SUMAPRODUCTO((MES($A$2:$A$23)=D9)*$B$2:$B$23)>E9<OPTION value==SUMAPRODUCTO((MES($A$2:$A$23)=D10)*$B$2:$B$23)>E10<OPTION value==SUMAPRODUCTO((MES($A$2:$A$23)=D11)*$B$2:$B$23)>E11<OPTION value==SUMAPRODUCTO((MES($A$2:$A$23)=D12)*$B$2:$B$23)>E12<OPTION value==SUMAPRODUCTO((MES($A$2:$A$23)=D13)*$B$2:$B$23)>E13</OPTION></SELECT></TD><TD align=right bgColor=#d4d0c8 width="3%">=</TD><TD align=left bgColor=white><INPUT name=txbFb116 size=120 value==SUMAPRODUCTO((MES($A$2:$A$23)=D9)*$B$2:$B$23)></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%">
</TD><TD align=middle bgColor=#d4d0c8><CENTER>A</CENTER></TD><TD align=middle bgColor=#d4d0c8><CENTER>B</CENTER></TD><TD align=middle bgColor=#d4d0c8><CENTER>C</CENTER></TD><TD align=middle bgColor=#d4d0c8><CENTER>D</CENTER></TD><TD align=middle bgColor=#d4d0c8><CENTER>E</CENTER></TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>1</CENTER></TD><TD align=middle bgColor=#ffffff vAlign=bottom>Fecha</TD><TD align=middle bgColor=#ffffff vAlign=bottom>Importe</TD><TD bgColor=#ffffff>
</TD><TD align=middle bgColor=#ffffff vAlign=bottom>Mes</TD><TD align=middle bgColor=#ffffff vAlign=bottom>Importe</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>2</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>27 sep 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 1,097</TD><TD bgColor=#ffffff>
</TD><TD align=right bgColor=#ffff99 vAlign=bottom>1</TD><TD align=right bgColor=#ffff99 vAlign=bottom>$ 0</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>3</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>11 jun 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 1,096</TD><TD bgColor=#ffffff>
</TD><TD align=right bgColor=#ffff99 vAlign=bottom>2</TD><TD align=right bgColor=#ffff99 vAlign=bottom>$ 0</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>4</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>07 nov 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 328</TD><TD bgColor=#ffffff>
</TD><TD align=right bgColor=#ffff99 vAlign=bottom>3</TD><TD align=right bgColor=#ffff99 vAlign=bottom>$ 0</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>5</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>10 sep 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 189</TD><TD bgColor=#ffffff>
</TD><TD align=right bgColor=#ffff99 vAlign=bottom>4</TD><TD align=right bgColor=#ffff99 vAlign=bottom>$ 0</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>6</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>04 jun 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 890</TD><TD bgColor=#ffffff>
</TD><TD align=right bgColor=#ffff99 vAlign=bottom>5</TD><TD align=right bgColor=#ffff99 vAlign=bottom>$ 0</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>7</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>19 nov 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 179</TD><TD bgColor=#ffffff>
</TD><TD align=right bgColor=#ffff99 vAlign=bottom>6</TD><TD align=right bgColor=#ffff99 vAlign=bottom>$ 4,462</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>8</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>06 jun 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 575</TD><TD bgColor=#ffffff>
</TD><TD align=right bgColor=#ffff99 vAlign=bottom>7</TD><TD align=right bgColor=#ffff99 vAlign=bottom>$ 1,219</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>9</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>05 jun 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 616</TD><TD bgColor=#ffffff>
</TD><TD align=right bgColor=#ffff99 vAlign=bottom>8</TD><TD align=right bgColor=#ffff99 vAlign=bottom>$ 1,754</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>10</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>07 dic 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 519</TD><TD bgColor=#ffffff>
</TD><TD align=right bgColor=#ffff99 vAlign=bottom>9</TD><TD align=right bgColor=#ffff99 vAlign=bottom>$ 1,286</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>11</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>19 oct 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 808</TD><TD bgColor=#ffffff>
</TD><TD align=right bgColor=#ffff99 vAlign=bottom>10</TD><TD align=right bgColor=#ffff99 vAlign=bottom>$ 3,377</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>12</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>18 oct 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 673</TD><TD bgColor=#ffffff>
</TD><TD align=right bgColor=#ffff99 vAlign=bottom>11</TD><TD align=right bgColor=#ffff99 vAlign=bottom>$ 1,866</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>13</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>24 oct 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 1,037</TD><TD bgColor=#ffffff>
</TD><TD align=right bgColor=#ffff99 vAlign=bottom>12</TD><TD align=right bgColor=#ffff99 vAlign=bottom>$ 519</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>14</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>03 jun 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 519</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>15</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>18 nov 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 677</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>16</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>04 jul 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 986</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>17</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>16 jun 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 766</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>18</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>10 nov 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 682</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>19</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>04 oct 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 501</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>20</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>08 oct 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 358</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>21</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>04 jul 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 233</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>22</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>18 ago 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 1,037</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD></TR><TR><TD align=middle bgColor=#d4d0c8 width="1%"><CENTER>23</CENTER></TD><TD align=right bgColor=#ffffff vAlign=bottom>26 ago 02</TD><TD align=right bgColor=#ffffff vAlign=bottom>$ 717</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD></TR><TR><TD colSpan=6>Hoja1</TD></TR></TBODY></TABLE>
To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

The above image was automatically generated by [HtmlMaker 2.10] If you want this FREE SOFT, click here to download
This code was graciously allowed to be modified: by Ivan F Moala All credit to Colo
</CENTER>
_________________
Regards,

Juan Pablo G.
MrExcel.com Consulting

[ This Message was edited by: Juan Pablo G. on 2002-05-30 15:46 ]
May 31st, 2002, 06:15 AM
luis romero

Renzo, Juan Pablo

Gracias por su ayuda, me quedo muy claro como resolver mi problema. ambas opciones funcionan perfectamente.

Saludos cordiales,
Luis Romero
May 31st, 2002, 07:15 AM
Renzo G

Juan Pablo,

Como haces para insertar esa hoja de Excel creo que asi es mas rapido que puedas comprender las preguntas.
Donde puedo encontrar ese programa?

Saludos,

Renzo
May 31st, 2002, 12:27 PM
Juan Pablo González

En este vínculo que aparece abajo de la página.

Download Colo's cool utility for displaying your Excel Worksheet on the board.
Mar 15th, 2010, 03:38 PM
mapavi

Re: SUMAR.SI por el mes de una fecha ???

Quisiera agregar un matiz adicional, que pasa cuando cambiamos de años. Como se resolvería este problema, porque me viene barbaro, pero tengo el problema que la serie es de 7 años.

Muchas Gracias
Mar 30th, 2010, 05:11 PM
Greg Truby

Re: SUMAR.SI por el mes de una fecha ???

Mapavi,

Usando el ejemplo provisto por JPG, uno podría hacer algo como:

<TABLE border=1 cellSpacing=0 borderColor=#c0c0c0 borderColorDark=#ffffff><TBODY><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=middle>Fecha</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=middle>Importe</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63>Año</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=middle>Mes</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=middle>Importe</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>27-Sep-02</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$1,097</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>2002</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>6</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>$4,462</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>11-Jun-02</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$1,096</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>2002</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>7</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>$1,219</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>7-Nov-02</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$328</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>2002</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>8</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>$1,754</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>10-Sep-02</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$189</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>2002</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>9</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>$1,286</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>4-Jun-02</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$890</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>2002</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>10</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>$3,377</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>19-Nov-02</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$179</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>2002</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>11</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>$1,866</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>6-Jun-02</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$575</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>2002</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>12</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffff00 height=25 vAlign=bottom width=63 align=right>$519</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>5-Jun-02</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$616</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>2003</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>1</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>-</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>12/7/2002</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$519</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>2003</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>2</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>$987</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>19-Oct-02</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$808</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>2003</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>3</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>$3,446</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>18-Oct-02</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$673</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>2003</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>4</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>$2,070</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>24-Oct-02</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$1,037</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>2003</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>5</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>-</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>3-Jun-02</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$519</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>2003</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>6</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>$812</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>18-Nov-02</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$677</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>2003</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>7</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>-</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>4-Jul-02</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$986</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>2003</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>8</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>$635</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>16-Jun-02</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$766</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>2003</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>9</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>-</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>10-Nov-02</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$682</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>2003</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>10</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>$1,334</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>4-Oct-02</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$501</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>2003</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>11</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>-</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>8-Oct-02</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$358</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>2003</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>12</TD><TD style="WHITE-SPACE: nowrap" bgColor=#99cc00 height=25 vAlign=bottom width=63 align=right>$2,904</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>4-Jul-02</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$233</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#00ccff height=25 vAlign=bottom width=63 align=right>2004</TD><TD style="WHITE-SPACE: nowrap" bgColor=#00ccff height=25 vAlign=bottom width=63 align=right>1</TD><TD style="WHITE-SPACE: nowrap" bgColor=#00ccff height=25 vAlign=bottom width=63 align=right>$1,659</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>8/18/2002</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$1,037</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#00ccff height=25 vAlign=bottom width=63 align=right>2004</TD><TD style="WHITE-SPACE: nowrap" bgColor=#00ccff height=25 vAlign=bottom width=63 align=right>2</TD><TD style="WHITE-SPACE: nowrap" bgColor=#00ccff height=25 vAlign=bottom width=63 align=right>-</TD></TR><TR><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=160 align=right>8/26/2002</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right>$717</TD><TD style="WHITE-SPACE: nowrap" bgColor=#ffffff height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#00ccff height=25 vAlign=bottom width=63 align=right>2004</TD><TD style="WHITE-SPACE: nowrap" bgColor=#00ccff height=25 vAlign=bottom width=63 align=right>3</TD><TD style="WHITE-SPACE: nowrap" bgColor=#00ccff height=25 vAlign=bottom width=63 align=right>$1,913</TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>28-Jun-04</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$213</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#00ccff height=25 vAlign=bottom width=63 align=right>2004</TD><TD style="WHITE-SPACE: nowrap" bgColor=#00ccff height=25 vAlign=bottom width=63 align=right>4</TD><TD style="WHITE-SPACE: nowrap" bgColor=#00ccff height=25 vAlign=bottom width=63 align=right>$2,229</TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>28-Oct-04</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$383</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#00ccff height=25 vAlign=bottom width=63 align=right>2004</TD><TD style="WHITE-SPACE: nowrap" bgColor=#00ccff height=25 vAlign=bottom width=63 align=right>5</TD><TD style="WHITE-SPACE: nowrap" bgColor=#00ccff height=25 vAlign=bottom width=63 align=right>-</TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>8-Oct-03</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$1,334</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#00ccff height=25 vAlign=bottom width=63 align=right>2004</TD><TD style="WHITE-SPACE: nowrap" bgColor=#00ccff height=25 vAlign=bottom width=63 align=right>6</TD><TD style="WHITE-SPACE: nowrap" bgColor=#00ccff height=25 vAlign=bottom width=63 align=right>$213</TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>23-Sep-04</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$1,282</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>24-Dec-03</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$1,482</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>1-Mar-04</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$1,913</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>21-Dec-04</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$1,486</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>3-Dec-03</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$930</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>28-Aug-04</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$1,295</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>23-Sep-04</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$1,946</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>9-Aug-03</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$635</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>17-Jul-04</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$1,034</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>3-Apr-04</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$247</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>19-Jan-04</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$1,659</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>28-Dec-04</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$322</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>16-Mar-03</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$1,870</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>9-Feb-03</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$987</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>15-Oct-04</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$1,322</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>13-Apr-03</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$1,905</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>25-Apr-04</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$1,035</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>4-Dec-03</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$492</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>8-Apr-04</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$947</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>18-Jun-03</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$812</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>30-Apr-03</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$165</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>11-Jul-04</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$184</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>19-Mar-03</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$1,576</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=160>22-Oct-04</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>$282</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD></TR></TBODY></TABLE>
Mar 30th, 2010, 05:12 PM
Greg Truby

Re: SUMAR.SI por el mes de una fecha ???

Aquí está otra vez, pero con las fórmulas. Pero tengo que decirle que para solucionar una situación así, usaría una Pivot Table (tabla dinámica) y no fórmulas.

<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0"><tr><td bgcolor="#FFFFFF" width="103" height="25" align="center" valign="bottom" style="white-space: nowrap">Fecha</td><td bgcolor="#FFFFFF" width="63" height="25" align="center" valign="bottom" style="white-space: nowrap">Importe</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFFFF" width="63" height="25" valign="bottom" style="white-space: nowrap">Año</td><td bgcolor="#FFFFFF" width="63" height="25" align="center" valign="bottom" style="white-space: nowrap">Mes</td><td bgcolor="#FFFFFF" width="294" height="25" align="center" valign="bottom" style="white-space: nowrap">Importe</td></tr><tr><td bgcolor="#FFFFFF" width="103" height="25" align="right" valign="bottom" style="white-space: nowrap">37526</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">1097</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFF00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">2002</td><td bgcolor="#FFFF00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">6</td><td bgcolor="#FFFF00" width="294" height="25" align="right" valign="bottom" style="white-space: nowrap">=SUMPRODUCT((MONTH(A$2:$A$50)=E2)*(YEAR(A$2:A$50)=D2)*$B$2:$B$50)</td></tr><tr><td bgcolor="#FFFFFF" width="103" height="25" align="right" valign="bottom" style="white-space: nowrap">37418</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">1096</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFF00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">2002</td><td bgcolor="#FFFF00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">7</td><td bgcolor="#FFFF00" width="294" height="25" align="right" valign="bottom" style="white-space: nowrap">=SUMPRODUCT((MONTH(A$2:$A$50)=E3)*(YEAR(A$2:A$50)=D3)*$B$2:$B$50)</td></tr><tr><td bgcolor="#FFFFFF" width="103" height="25" align="right" valign="bottom" style="white-space: nowrap">37567</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">328</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFF00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">2002</td><td bgcolor="#FFFF00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">8</td><td bgcolor="#FFFF00" width="294" height="25" align="right" valign="bottom" style="white-space: nowrap">=SUMPRODUCT((MONTH(A$2:$A$50)=E4)*(YEAR(A$2:A$50)=D4)*$B$2:$B$50)</td></tr><tr><td bgcolor="#FFFFFF" width="103" height="25" align="right" valign="bottom" style="white-space: nowrap">37509</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">189</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFF00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">2002</td><td bgcolor="#FFFF00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">9</td><td bgcolor="#FFFF00" width="294" height="25" align="right" valign="bottom" style="white-space: nowrap">=SUMPRODUCT((MONTH(A$2:$A$50)=E5)*(YEAR(A$2:A$50)=D5)*$B$2:$B$50)</td></tr><tr><td bgcolor="#FFFFFF" width="103" height="25" align="right" valign="bottom" style="white-space: nowrap">37411</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">890</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFF00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">2002</td><td bgcolor="#FFFF00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">10</td><td bgcolor="#FFFF00" width="294" height="25" align="right" valign="bottom" style="white-space: nowrap">=SUMPRODUCT((MONTH(A$2:$A$50)=E6)*(YEAR(A$2:A$50)=D6)*$B$2:$B$50)</td></tr><tr><td bgcolor="#FFFFFF" width="103" height="25" align="right" valign="bottom" style="white-space: nowrap">37579</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">179</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFF00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">2002</td><td bgcolor="#FFFF00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">11</td><td bgcolor="#FFFF00" width="294" height="25" align="right" valign="bottom" style="white-space: nowrap">=SUMPRODUCT((MONTH(A$2:$A$50)=E7)*(YEAR(A$2:A$50)=D7)*$B$2:$B$50)</td></tr><tr><td bgcolor="#FFFFFF" width="103" height="25" align="right" valign="bottom" style="white-space: nowrap">37413</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">575</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#FFFF00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">2002</td><td bgcolor="#FFFF00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">12</td><td bgcolor="#FFFF00" width="294" height="25" align="right" valign="bottom" style="white-space: nowrap">=SUMPRODUCT((MONTH(A$2:$A$50)=E8)*(YEAR(A$2:A$50)=D8)*$B$2:$B$50)</td></tr><tr><td bgcolor="#FFFFFF" width="103" height="25" align="right" valign="bottom" style="white-space: nowrap">37412</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">616</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#99CC00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">2003</td><td bgcolor="#99CC00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">1</td><td bgcolor="#99CC00" width="294" height="25" align="right" valign="bottom" style="white-space: nowrap">=SUMPRODUCT((MONTH(A$2:$A$50)=E9)*(YEAR(A$2:A$50)=D9)*$B$2:$B$50)</td></tr><tr><td bgcolor="#FFFFFF" width="103" height="25" align="right" valign="bottom" style="white-space: nowrap">37597</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">519</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#99CC00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">2003</td><td bgcolor="#99CC00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">2</td><td bgcolor="#99CC00" width="294" height="25" align="right" valign="bottom" style="white-space: nowrap">=SUMPRODUCT((MONTH(A$2:$A$50)=E10)*(YEAR(A$2:A$50)=D10)*$B$2:$B$50)</td></tr><tr><td bgcolor="#FFFFFF" width="103" height="25" align="right" valign="bottom" style="white-space: nowrap">37548</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">808</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#99CC00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">2003</td><td bgcolor="#99CC00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">3</td><td bgcolor="#99CC00" width="294" height="25" align="right" valign="bottom" style="white-space: nowrap">=SUMPRODUCT((MONTH(A$2:$A$50)=E11)*(YEAR(A$2:A$50)=D11)*$B$2:$B$50)</td></tr><tr><td bgcolor="#FFFFFF" width="103" height="25" align="right" valign="bottom" style="white-space: nowrap">37547</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">673</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#99CC00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">2003</td><td bgcolor="#99CC00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">4</td><td bgcolor="#99CC00" width="294" height="25" align="right" valign="bottom" style="white-space: nowrap">=SUMPRODUCT((MONTH(A$2:$A$50)=E12)*(YEAR(A$2:A$50)=D12)*$B$2:$B$50)</td></tr><tr><td bgcolor="#FFFFFF" width="103" height="25" align="right" valign="bottom" style="white-space: nowrap">37553</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">1037</td><td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"></td><td bgcolor="#99CC00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">2003</td><td bgcolor="#99CC00" width="63" height="25" align="right" valign="bottom" style="white-space: nowrap">5</td><td bgcolor="#99CC00" width="294" height="25" align="right" valign="bottom" style="white-space: nowrap">=SUMPRODUCT((MONTH(A$2:$A$50)=E13)*(YEAR(A$2:A$50)=D13)*$B$2:$B$50)</td></tr></table>

Atte,