You should be able to get what you're asking for by using a Pivot Table.

Try this....

<Data<Pivot Table
Use: Excel
Select your data
Click the [Layout] button

ROW: Drag the LaborCode field here
COLUMN: Drag the AccNo field here
DATA: Drag the Weekly Total field here
If it doesn't list as Sum of Weekly Total...dbl-click it and set it to Sum
Click [OK]
Select where you want the Pivot Table...and you're done!

That will create the kind of table you described.

To refresh the Pivot Table, just right click it and select Refresh Data

For much more information on how to use Pivot Tables, See Debra Dalgleish's
contirbution to Jon Peltier's website:
http://peltiertech.com/Excel/Pivots/pivotstart.htm

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Jess" wrote:

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.