Sub totals in an expense worksheet

[rushd45]

Hi all,

I've asked this before and got some repsonses, but I still don't understand
what I need to do. So I have copied part of my spreadsheet and will use it
as a guide. I can sum up the Amount, Tax and Total columns with no trouble.
What I want to do is take the categories column and total each individual
category up.

Any help would be greatly appreciated.

Date Store / Person Description Categories Quanity Amount Tax Total
Cash/CC/Check #
4/19/2003 Wayne Cooper Pressure tank and pump Main Water $500.00
$500.00 cash
9/23/2003 Interstate Towing Container fee Container $325.00
$325.00 #779
10/1/2003 Kinko's copies Copies $17.85 $1.35 $19.20 cc
10/7/2003 Container 40' container Container $1,550.00 $1,550.00
cc
10/21/2003 Gersins Door Container Container $145.26 $145.26 #782
10/30/2003 Interstate Towing Container fee Container $50.00 $50.00
#783
11/11/2003 Wayne Cooper 500 Gal Propane Tank Propane $275.00
$275.00 #793
11/17/2003 Energy Efficency Hot/Dry Climate Book Book $50.75
$50.75 cc
12/1/2003 Const Book Express Building with SIPs Book $41.90 $41.90
cc


Thanks
Rush

 

[rushd45]

I redid the copied spreadsheet, I hope it comes thru better

Description Categories Amount Tax Total
Pressure tank Main Water $500.00 $500.00
Container fee Container $325.00 $325.00
Kinko's Copies $17.85 $1.35
$19.20
40' container Container $1,550.00 $1,550.00
Door Container Container $145.26 $145.26
Interstate Towing Container $50.00 $50.00
500 Gal Tank Propane $275.00 $275.00
Energy Book Book $50.75
$50.75
Building with SIPs Book $41.90
$41.90



Hi all,

I've asked this before and got some repsonses, but I still don't understand
what I need to do. So I have copied part of my spreadsheet and will use it
as a guide. I can sum up the Amount, Tax and Total columns with no trouble.
What I want to do is take the categories column and total each individual
category up, I don't need the description column.

Any help would be greatly appreciated.

Thanks
Rush