Blog


← Back to BLOG

24
Mar
2015

Track Spending Habits with AutoSum

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

navitend can help you. Call 973.448.0070 or setup an appointment today.

Testimonials

  • navitend’s approach to customer service is greatly appreciated here at TeamPar.  Ensuring that we are well protected from a technology standpoint provides us with peace of mind to continue our day to day operations and that they are looking out for our company's best interest. 

    Debbie Broslawski TeamPar
  • “Navitend’s expertise helped our firm over the past year to effectively elevate our I.T. game, powering our website into a highly interactive tool. Well done to Frank and his team!”  

    Chuck Steege, CFP®, CEP, President, SFG Wealth Planning Services, Inc.
  • "I look forward to working with you again in the future. Once again, thanks to your organization for your prompt response."

    Luke Wolters / Luke Wolters Tax Consultants
  • "Thanks so much again for taking care of everything in such an expedient manner. It's a pleasure to work with navitend and its staff as always!"

    Lawrence Wolfin / Textol Systems, Inc.
  • "Thanks so much!  You are a class act!  
    You and your team have really done an excellent job on this!"

    Steve Van Ooteghem, The C12 Group in Houston, Texas
  • "We've dedicated our lives to growing our retail and ecommerce business and it's a relief to have found a company like navitend who treats our business likes it's their own. navitend's personal approach to project management and problem solving are top-notch."

    Stamatis, Co-owner Twisted Lily, Fragrance Boutique and Apothecary
  • "navitend has been a great IT partner for our company.  Their helpdesk response time is the best I have experienced in my 30 year career.  navitend has helped me to have great IT services without the need to have a full time, in house, technician at significant savings to our company."

    Bob Bradley, President, Bradley Graphics
  • "Our company is more efficient and has grown as a result of navitend’s work. navitend helped us get to the next level."

    Greg Niccolai / Madison Insurance
  • "I appreciate that they didn’t just build the application. They made it better by bringing ideas to the table that not only made for a better user experience, but also kept the development costs down."

    Andy Lynch / North Star Marketing