Exceljet

Quick, clean, and to the point

Project complete percentage

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 
Excel formula: Get percentage of total
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...
Excel formula: Percent of goal
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
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.

500 Formulas | 101 Functions

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.