I have a column with agent commissions for sales orders. Next to this column I have a column with the agents identifier (names in this case). I want to create individual cells that total each agents commissions at the bottom of the spreadsheet.

Have a look at the attached. Without an example worksheet it's hard to tailor make an example, but it should give you the idea.

I've included a SUMPRODUCT and a SUMIF version.

You could also use a pivot table.

Let us know if you need further help with adapting it to your specific workbook.

Works perfectly - thanks very much!