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.

## Keep Learning

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.

Sources:

## Related Questions

• 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.

Filed Under:
• 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'.

Filed Under:
• 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.