Hi Kileyc,

Suggest you to look into SumIFs or Sumproduct function ... post the workbook in case of any issues, as suggested by Vinoth. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>