Sums-Code October November

[Khalil Handal]

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
School 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 looks like this:



Code October November... 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
item and put it in the row of October the line of 100. the same for the rest
of the months.



Note: the number of particulars differs from one month to another.



Help is appreciated



Khalil

[Khalil Handal]

Sorry,
Reposted to make more clear.

Khalil

"Khalil Handal" <[email protected]> wrote in message
news:[email protected]...
> 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
> School 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 looks like this:
>
>
>
> Code October November... 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
> item and put it in the row of October the line of 100. the same for the
> rest of the months.
>
>
>
> Note: the number of particulars differs from one month to another.
>
>
>
> Help is appreciated
>
>
>
> Khalil
>
>