How to Get a Percent of a Total on Microsoft Office Excel 2007

By Mark Kennan

Microsoft Excel is a spreadsheet program that is part of Microsoft Office 2007. In the program, you can use the values found in other cells as part of formulas. One use for this is to get a percent of a total. This is useful for determining the portion of a sum, such as finding how much tax you will pay on your total income.

Things You'll Need

  • Microsoft Excel

Step 1

Use the SUM function to total the values of the cells you want to include in the total. For example, if you want to determine the total of your income for the year and your income for each month is listed in cells A1 through A12, you would use the function SUM(A1:A12).

Step 2

If you want to take a percentage of the total, enter in a new cell "=SUM(Cells you want to include)*Percentage." For example, if you wanted to use the income mentioned in step 1 and find 10 percent of that income, you would enter "=SUM(A1:A12)*0.1."

Step 3

If you want to use a percentage found in another cell, enter that cell instead of a number for percentage in the formula "=SUM(Cells you want to include)*Percentage." For example, if you had the income tax percentage in cell C5, you would enter "=SUM(A1:A12)*C5".

Tips & Warnings

  • Make sure you start your formula with the "=" or Excel will not know that it is an equation.