Check out "PIVOT TABLES" in the Help Menu: They take some "trial and
error" to get exactly what you want. But since they use the data from
the spreadsheet - your only part is to place the columns and rows so
you get the data "you want." Once you have what you want then you can
select the DATA area of the PIVOT TABLE to either SUM, COUNT, AVERAGE,
etc. "PIVOT TABLE" is located under DATA on the menu bar.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=501388