Q:

# How do you subtract a percentage from a sum in Excel?

A:

You can use several techniques to subtract a percentage from a sum in Excel. The Houston Chronicle elaborates on a simple method that can be used in versions of the software up to MS Excel 2013.

## Keep Learning

Credit: Don Bayley E+ Getty Images

1. ### Calculate the sum

The first step is to calculate the sum with the formula “=sum(cellX:cellY)” entered below the cell range of a sum. For example, the sum for cells A1 to A10 is calculated with the formula “=sum(A1:A10)” inserted into the cell A11.

2. ### Enter percentage to be deducted

The percentage to be deducted from the sum should be entered into the adjacent cell of the sum. In this example case, cell B11.

3. ### Enter final calculation formula

The formula “=cell of the sum-(cell of the sum * cell of the percentage followed by %)” is used to calculate the final result. In the example above, formula “=A11-(A11*B11%)” would deduct a percentage set in the cell B11 from the sum of the cell range A1 through A10.

Sources:

## Related Questions

• 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 listin... Full Answer >
Filed Under:
• 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 u... Full Answer >
Filed Under:
• A: Formulas can be written in different ways on Excel. They can be created using constants and calculation operators or by use of cell references and names. A... Full Answer >
Filed Under:
• A: Microsoft and GCF Learn Free offer free online courses for Excel. Whereas the training center by Microsoft has courses for Windows, Mac OS X, Android, iOS ... Full Answer >
Filed Under:
PEOPLE SEARCH FOR