Excel formula: Project complete percentage

Generic formula

=COUNTA(range1)/COUNTA(range2)

Summary

To calculate the percentage complete for a project with a list of tasks, you can use a simple formula based on the COUNTA function. In the example shown, the formula in F6 is:

=COUNTA(C5:C11)/COUNTA(B5:B11)

Explanation

At the core, this formula simply divides tasks complete by the total task count:

=complete/total

which is then formatted as a percentage.

To count complete tasks, we count non-blank cells in the range C5:C11:

=COUNTA(C5:C11)

To count total tasks, we count non-blank cells in the range C5:C11:

COUNTA(B5:B11)

Unlike the COUNT function, which counts only numeric values, COUNTA will count cells that include numbers or text.

Author

Dave Bruns

Related formulas

Get percentage of total

In the example, D6 contains the formula below, copied down: = C6 / $C$11 In cell D6, the result of the calculation is .625. The Percentage number format is applied to cell D6, with 2 decimal places, so Excel displays .625 as 63%. The reference to...

Percent of goal

When working manually, percentage results are calculated by dividing one number by another (for example, a part by a whole) to get a decimal value, then multiplying by 100 to express as a percentage. Excel can display decimal or fractional values...

Related functions

Excel COUNTA Function

The Excel COUNTA function returns the count of cells that contain numbers, text, logical values, error values, and empty text (""). COUNTA does not count empty cells.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.