I have a large spreadsheet > 15000 rows that I need to summarise into a small table.
Essentially its a list of invoices grouped into departmental code, of which I need a subtotal amount.
column A - supplier
comumn B - code
column C - amount
I need to group the total amount of column C per column B (code). So if 300 invoices at various amounts are against column B I need a total of how much those rows total to per code. Hope that makes sense. I could also do with the subtotals being displayed somewhere that just lists each unique code and each subtotal. Maybe another sheet?