Hi Denny,

Am Sat, 23 Nov 2013 21:51:54 +0100 schrieb Claus Busch:

the easiest way to do it is a Pivot table
Drag Category to the row area and the storesales to the value area.

please look he
https://skydrive.live.com/#cid=9378A...121822A3%21326
for the workbook "Subtotals"


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2