What Is the Formula in Excel to Divide a Sum?

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.

ADVERTISEMENT