Adding a formula to a button in Microsoft Excel
Trouble viewing the screencast at work? Try signing up for new issues on our home page with your personal email address and watch the screencast from home.
You can use the "=SUM" Excel formula with the click of a button. Follow these steps to find out how much money you should record against your budget this month:
1. Let's set up a simple Excel spreadsheet that lists the weeks of the month and days of the week. Feel free to enter more specific dates in your spreadsheet. Select all cells that will contain currency data and click the Accounting Number Format.
2. Enter the total for each day. This will be easy to do if you type = and then record each item separated by + signs. For instance, a cell containing =2.50+10+2.5 will display the sum, $15.00.
3. To calculate weekly totals, select all days of the week and the empty cell to the right of them; then click the AutoSum button.
If you enter all data for the entire month at once, select all weeks and the empty Weekly Total cells; then click AutoSum.
4. Find the total for the month by selecting the Weekly Totals and the empty cell where the monthly total should be displayed. Click AutoSum to calculate the grand total.
If you have an unanswered technical question that you would like to see addressed in an upcoming issue, feel free to email it to social@navitend.com.
Contact us at 973.448.0070