Q:

What is the formula in Excel to divide a sum?

A:

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.

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

Related Questions

  • Q:

    How do you create a schedule in Excel?

    A:

    Free schedule templates are available for download from Microsoft's official website to begin creating schedules in Excel. Ensure the template is compatible with the computer's current version of Windows before performing the download.

    Full Answer >
    Filed Under:
  • 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 round numbers in Excel?

    A:

    Though there are several functions in Excel for rounding numbers, the ROUND function is the most basic and the most commonly used. Keep in mind that when using any rounding function, its result is always treated as rounded by any formulas that reference it and can potentially alter calculations.

    Full Answer >
    Filed Under:
  • Q:

    How do you unhide rows in Excel?

    A:

    To unhide rows in Excel, open the Excel worksheet, select the first hidden row on the worksheet, navigate to the Home tab, select Format, move the mouse pointer to Hide & Unhide, and press Unhide Rows. You can also unhide a row by changing the size of the cell.

    Full Answer >
    Filed Under:

Explore