Numbers 09 - I need an experienced formul-ologist:
So I have a spreadsheet.
So I have the days of the week and amount, example:
MON +500
TUES +89
etc..
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.
THANKS!