Subtotals dependant on category column (excel rookie)

[Steve Barker]

I'm making a record sheet of sorts in excel to keep track of truck repairs
and maint. Each line (row) will contain a CATEGORY and the AMOUNT of the
repair among other things. I want to be able to subtotal the different
categories off to the side of the sheet by having excel add the AMOUNT to
the appropriate category total depending on the CATEGORY column on THAT
line. I'm not a total novice with excel, but durn close. <G>



Thanks!


--
Steve Barker
Stilwell, Kansas
UP (MoPac) Coffeyville Sub MP 308
Nikon Coolpix 995
PSP 8.00

=========

 

[Guest]

One way: =SUMIF($B2:$B4,D1,$A2:$A4)

Column A is the Amount
Column B is the Category
D1 is the first Category to subtotal, E1 is the second,
etc. Formula is in D2, and can copy it to E2, etc.

 

[Steve Barker]

Thanks so much. This does exactly what I wanted. I read and re-read the
"sumif" help file, but would have never got it to this point. <G>.

--
Steve Barker
Stilwell, Kansas
UP (MoPac) Coffeyville Sub MP 308
Nikon Coolpix 995
PSP 8.00

=========