Help for a complete novice

I have a spreadsheet where I record outgoings on a weekly basis. The 1^st column lists type of expense, the 2^nd column records the name of the shop or company, the next 52 columns are for weeks and the final column is for a running total for the shop or company.
What I would like to do is have a total for each category as defined in column 1 but being a complete novice with regard to Excel I haven’t got a clue how to do it, if someone could point me in the right direction I would be most grateful.