Sort by project#
DataSubtotals

-- Carlos

"Barb R." wrote in message
...
I have data in the following format

Project # FY02 FY03 FY04 FY05
1 $100 $200 $300 $400
2 $100 $200 $300 $400
2 $200 $200 $300 $400

I want to have resulting data in the following form
Project # FY02 FY03 FY04 FY05
1 $100 $200 $300 $400
2 $300 $400 $600 $800

where I only have one observation per project number and the data for each
FY is the sum of all entries for that project. Can this be done with
Pivot
Tables or is another way better. If I'm reading this right, in order to
do
this with a pivot table, I need to "stack" the FY data and then split it
back
out. Any other way?