sorry, not sure of your layout now
there a few ways to sum values
you could use sumif()
sumifs()

can you load an example spreadsheet and give also examples of the results you expect and the data entered