adding values from multiple rows

hi, i have a spreadsheet which lists drivers and the values that they have earned
there are 10+ drivers all on different rows. their name is in one column and the value is in another column. their names are not always in the consecutive rows.

how on earth do I create a table at the bottom of the sheet totalling the drivers individual totals as I input their details?

help!

Thanks
Jo

From your description (and I hope I understand your request), this could be done using Index Match and SUMPRODUCT

1. In another column (say D2), gather the unique drivers name: =IFERROR(INDEX($A$2:$A$101,MATCH(0,COUNTIF($D$1:D1,$A$2:$A$101),0)),"")

• This is an array formula, so you will have to simultaneously press the SHIFT+CTRL+ENTER keys

• Drag formula down until you receive a blank field

2. In another column (Say E2), use SUMPRODUCT to total the earnings for each driver: =SUMPRODUCT(--($A$2:$A$101=D2),$B$2:$B$101)

• This is NOT an array formula, so just press the ENTER key

• Drag formula down until you receive a blank field

See attachment