I have two colums - 1) Expenditure Type, 2) Expenditure Amount. with many
rows. At the bottom of the spreadsheet, I'd like to display the total
expenditure amount corresponding to each Expenditure Type:

Eg:
Expenditure Type|Expenditure Amount
Stationery|200
Stationery|200
Gifts|200
Essentials|100
Stationery|300


At the end of the spreadsheet:
Stationery|Gifts|Essentials
700|200|100

Thanks