excel.png

Please see attachment (Hope its worked!)

Company names column B
Amounts Column E

What I need to do is have a filter/sort where a line below each different company appears adding up the respective companies amounts, its not as simple as 4 companies as you can see in the picture, the sheet goes past row 1500.

So possibly have just one line for each company with the total next to it.

Can anybody help?

Thanks