Hi,

I have 13 worksheets (12 months, summary), for each month I have 1 column
for item (B) and 1 column for codes for each item (EI). Item start at row 7.

The item codes are: 100, 200, 300, . 900. Sub items have the codes like 710,
720 or 510, 520, not all of them have sub items code.

Column C, D contains currency. See table below:

A B C D
EI
Date Particulars
Code
10/01/05 Food 38.00 0.00 710
10/01/05 Food 16.00 0.00 710
10/01/05 Supply 50.00 0.00 800
10/01/05 Books 48.00 20.00 710
10/01/05 S. Supply 812.00 0.00 820
01/01/05 Equipment 156.00 0.00 500
10/01/05 Garden 110.00 0.00 500

The summary sheet - in the same work book - looks like this:
(code 710 is an example)
Code October November December ...
all 2 months
710 (38+0+16+0+48+20)
200
210
220
500

I need to lookup the codes and sum the amounts in column C and D for that
code item and put it in the row of October in summary sheet. The same for
the rest
of the months.

Note: the number of particulars differs from one month to another.
one month 10 rows another 20 rows depending on expences.

Help is appreciated

Khalil Handal