Hi Jasonjhc,

Welcome to the forum.
If you want to sum all the values against Y, you can use SumIF function.. try it and in case of any issues, upload a sample workbook. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>