Q:

What is the formula in Excel to divide a sum?

A:

Quick Answer

To divide by the sum of cells A1 through A10 by 2 in Excel, use the formula: =SUM(A1:A10)/2. It is also possible to enter numbers directly into the formula.

Continue Reading

Full Answer

When entering a formula in Microsoft Excel, it is possible to use "pointing" to select the cells to reference. To "point" at a cell, click on it while editing the formula. Pointing minimizes the risk of referring to the wrong cell in a formula. Excel follows the mathematical order of operations, so it is possible to write more complex equations by using the mathematical operators * for multiplication, / for division, + for addition and - for subtraction.

Learn more about Software

Related Questions

  • Q:

    How do you merge cells in Excel?

    A:

    To merge cells in Excel, simply highlight the cells you want to merge, right-click, and select Format Cells. Next, select the Alignment tab, and check the Merge Cells box. The process should take less than one minute to complete.

    Full Answer >
    Filed Under:
  • Q:

    How do you create a spreadsheet using Excel?

    A:

    To create a spreadsheet, open Excel and begin entering information into the cells. Save the spreadsheet to the hard drive by clicking File and Save. In Excel, every column has a capital letter at the top, and each row has a number on the left. These are combined to reference specific cells, for example 'A1' or 'C12'.

    Full Answer >
    Filed Under:
  • Q:

    How do you remove duplicates in Excel?

    A:

    To remove duplicates in Excel, select the cells that include the duplicates, click on the Data tab, and select the Remove Duplicates option. Click OK on the dialogue box to delete the duplicate cells.

    Full Answer >
    Filed Under:
  • Q:

    How do you hide cells in Excel?

    A:

    To hide cells in Excel 2010, first identify the row or column you want to hide. With the row or column highlighted, select Format, Visibility and Hide Rows or Hide Columns.

    Full Answer >
    Filed Under:

Explore