So I have a spreadsheet.

So I have the days of the week and amount, example:

MON +500
TUES +89

The weeks go on and on. THEN, I have a small table (we'll call it table X) that lists the days of the week and the total amount overall.

Is there a way that I can set up table X so that once I type in "MON +500". Table X automatically adds +500 to Monday. Basically searching for all "Mondays" and adding that amount together.