calculate total for departments

Hi All,

I am new here but have used Excel for a long time and I have come up against a problem and not too sure of the best solution.

I have a spreadsheet which looks similar to the below

Department	Cost
Department 1	£50
department 2	£20
Department 1	£215
Department 3	£5
Department 3	£456
Department 2	£123
Department 1	£57

I need a cell on another sheet (same workbook) to give me the total for Department 1 then another for Department 2 ......

I know I could add an extra columns to the right side for each department but I would like to avoid this if possible, and to make it even more complicated I need to avoid macros as it needs to be useable in O365 web interface. There will likely be many many rows of data.

any ideas will be great, I am currently stuck

many thanks

AMAZING!!!!!

Exactly what I needed. many thanks for the super fast response!!!!!