How to Enter Formulas in Excel & Divide the Sum of Several Numbers by a Number

Written by stephanie ellen
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Enter Formulas in Excel & Divide the Sum of Several Numbers by a Number
Get Excel to do the tedious calculations for you. (calculadora image by Norberto Lauria from

Microsoft Excel is a helpful program to organise large amounts of data. It can also help remove some mundane tasks, such as performing accounting functions by hand. Instead of adding up a series of numbers and then dividing by another number manually, you can enter an Excel formula into a spreadsheet cell to do the task for you. Whenever the amounts are updates, Excel will automatically calculate the new figure. Excel formulas are preceded in a cell by the "=" sign; when you type the "=" sign in a cell first, Excel knows to expect a formula.

Skill level:

Things you need

  • Microsoft Excel

Show MoreHide


  1. 1

    Click on an empty cell in your spreadsheet.

  2. 2

    Type an "=" sign.

  3. 3

    Type the following formula into the cell: UM(A1:A10).

  4. 4

    Replace "A1:A10" with the cell locations of the numbers you want to add. In this example, the series of numbers is in cells A1 through A10.

  5. 5

    Type a division sign "/" followed by the number you want to divide by. For example, if you wanted to divide the total of cells A1 to A10 by 3, type "/3."

  6. 6

    Press the "Enter" key; Excel will perform the calculation.

Tips and warnings

  • Instead of typing SUM(A1:A10), you can get Excel to Autosum the cells for you and insert the formula. Highlight the cells you want to sum by left clicking at the top left of the cells and then dragging the cursor to the bottom right. Click on the "Home" tab, then press the Autosum symbol, "'."

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.