is this what a pivot tables does

[Guest]

I have an Excel spreadsheet with the following dat
cost area yea
23 a 199
0 a 199
0 a 199
8 c 199
2 c 199
17 a 200
2 a 2000...et

I would like to group together all the area a's for each year b's for each year etc to get a total cost for each area each yea
i.e

total area yea
23 a 199
10 c 199
19 a 200

Am I able to do this using a pivot table, or is there a better way
Many thanks for any help

 

[Ken Wright]

That's what a pivot table does for you in seconds

A good intro:-

http://peltiertech.com/Excel/Pivots/pivotstart.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

I have an Excel spreadsheet with the following data
cost area year
23 a 1999
0 a 1999
0 a 1999
8 c 1999
2 c 1999
17 a 2000
2 a 2000...etc

I would like to group together all the area a's for each year b's for each

year etc to get a total cost for each area each year

 

[Frank Kabel]

And some more intros:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm