• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Get Annual Sales in Excel

How to Get Annual Sales in Excel

By: Shea Laverty
  • Share
  • Share on Facebook

You don't need to learn a complicated Excel function to calculate your company's annual sales. The program's SUM function returns the total sum from all of the values in specific cells. For example, the function can add the value of each cell in a range of consecutive cells, such as a range of cells representing the 12 months of the year. You only need your monthly sales data to use the function to get your annual sales total.

Step

Open a new spreadsheet, then enter the name of each month of the year in each cell from A1 to A12. For example, type "January" in cell A1, and then type "February" in cell A2.

Step

Enter the total sales for each respective month in cells B1 through B12. For example, enter sales for the month of January in cell B1, and then enter sales for February in cell B2.

Video of the Day

Step

Enter "Annual Sales" in cell A13, and then enter "=SUM(B1:B12)" in cell B13.

Step

Press the "Enter" key. The SUM function adds the range of values and displays the annual sales number in cell B13.

Show Comments

Related Articles

How to Calculate P Value in Excel

How to Calculate P Value in Excel

Around The Home
Productivity
By: Nina Nixon
How to Copyright Excel Files

How to Copyright Excel Files

Around The Home
Productivity
By: Vera Leigh
How to Make an Employee Weekly Performance Tracker Using Excel

How to Make an Employee Weekly Performance Tracker Using Excel

Around The Home
Productivity
By: Peter Franczyk
How to Calculate Gas Mileage in Excel

How to Calculate Gas Mileage in Excel

Around The Home
Productivity
By: Cindy Gierhart
How to Round Up to the Next Value in Excel VLOOKUP

How to Round Up to the Next Value in Excel VLOOKUP

Around The Home
Productivity
By: Ryan Menezes
How to Use Minus Function in Excel

How to Use Minus Function in Excel

Around The Home
Productivity
By: Lysis
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2019 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.