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.

  Know More

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:

    What is "mean" in Excel?

    A:

    In Excel, the mean function is used to calculate the average of a set of numbers. The numbers used can come from any cell in an Excel spreadsheet by listing the cells involved into the average function box.

    Full Answer >
    Filed Under:
  • Q:

    How do you subtract dates in excel?

    A:

    To subtract dates in Excel, simply enter the following formula: "=A3-A2", assuming that cells A3 and A2 contain the dates that need to be subtracted. This will output the difference between the two dates, expressed in days.

    Full Answer >
    Filed Under:
  • Q:

    How do you convert a decimal to time in Excel?

    A:

    For Excel 2010, to convert a decimal into a standard time format, enter the formula "=TEXT([desired cell number]/24, "h:mm")" and replace "[desired cell number]" with the correct cell number. This will change the number into a standard hours, minutes and seconds format.

    Full Answer >
    Filed Under:
  • Q:

    How do you calculate covariance in Excel?

    A:

    To calculate covariance in Excel, use the covariance function. The syntax of the function is: COVARIANCE.P(array1,array2), where array1 and array2 are the two sets of data for which the covariance is being determined.

    Full Answer >
    Filed Under:

Explore