HI GUYS,

I need help with this problem:


In a worksheet i have all the transactions of income and expenses. Each transaction has been classified with date, account ID, description and amount of the transaction.

In another worksheet i have a summary where all the months of the year as a column and each account as a row, to get each Income or expense classified according to the account ID and month of execution.

What i need in the summary is a sum of all the transactions done during that month for each specific account ID.

Here are portions of the worksheet so you can see what i mean.

FECHA ACCOUNTID DESCRIPCION GASTOS INGRESOS TOTAL
02/01/2013 900101 Pago de mantenimiento Local 05 mes de Enero 2,408.70 2,408.70
05/01/2013 900101 Pago de mantenimiento enero de Local 06 4,828.80 7,237.50
08/01/2013 905452 Emitido a nombre de DICOM por compra 96.00 7,141.50
08/01/2013 906452 Emitido a nombre de XXXXX por compra 196.00 6,945.50



ene-13 feb-13 mar-13 abr-13 may-13
ID CUENTA EXPENSES - - - - -
910100 SUELDOS Y BENEFICIOS - - - - -
910101 Sueldos y Salarios
910102 Vacaciones
910103 Horas Extras
910104 Bonificaciones
910105 Comisiones
905452 PAPER AND SOAP
906452 COMPUTER MAINTENANCE