I have created a report in Excel that has the following:
1st Column ---- 2nd Column ---- 3rd Column
Menu Items ---- Daily ---- MTD
Food $50.00 $1,500.00
Liquor $125.00 $2,500.00
Beer $500.00 $1,500.00
Wine $250.00 $5,000.00
My issue is: I enjoy making forms and reports. I am uneducated as far as using formulas. I was able to google and get some answers that helped me with the Daily, but am lost on how to create a formula for MTD.
The 2nd Column is entered daily. Then the next day, I click on Clear Daily Contents and start anew. I would like the MTD Column to be a constant running total and then, at the end of the month, have a Clear MTD Contents.