Sally - What I think you want to do is what "PIVOT TABLES" are made to
accomplish. I have attached a small spreadsheet with a generated pivot
table in it.
You might have to do a little "trial and error" and review of "PIVOT
TABLES" to get the results you want - but they can do a lot of things.
Here is what the results can look like -
Sum of Amount MONTH
CO 11 12 Grand Total
Apple 5200 3000 8200
Orange 800 800
Peach 6000 6000
Grand Total 12000 3000 15000
+-------------------------------------------------------------------+
|Filename: ExcelSample.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=4128 |
+-------------------------------------------------------------------+
--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile:
http://www.excelforum.com/member.php...o&userid=29640
View this thread:
http://www.excelforum.com/showthread...hreadid=494243