Hi...well here's my problem..and i need the solution asap.the columns below
are in one sheet.what i want is the weekly total for each account number
specific to each laborcode.eg=for account 1000,i want to calculate the weekly
total for labor codes 5006 and 5000. All in another sheet.

A B C
Accno LaborCode Weekly Total

1000 5006 39.5
2001 5006 4.5
2002 5000 2.5

1000 5006 29
2002 5006 11
2001 5000 1


I want my result to look like this but in another sheet or even the same
sheet.

LC 1000 2000 2001

5000 ? ? ?
5001
5006

Please get back to me anyone..thank you.