SUMIF with unique indexing

Hi all,

I am trying to generate a calculation which shows where a unique ID has separate rows and totals the value for all cells in a column where that unique identifier is present in the row.

Below is an example.  I want a formula to sum the 'value' for all cells where the ID is same into the corresponding row in the first table.  I've tried a sumif, however it only returns the first find.  So where the first value is 0 it returns that, despite being other rows where the ID is, and the row contains data for the column of 'value'

I'm sure i'm missing a simple step, but can't quite figure it out.

Thanks