Percentage based on "Complete"

Cory Larsen

Hello! I have a column labeled "Line Status" with many different statuses. One status is "complete" and I would like to produce a percentage based on the # of times complete exists compared to the number of lines with any status at all. Each line is a step in our process, and as we mark each line complete I would like it to show what percentage of all lines are complete - Thank you for any help!

Michael Culley

I would do something like this:

=countif([Line Status]:[Line Status],"Complete") / countif([Line Status]:[Line Status],<>"")

Basically counting all completes and dividing it by all non-blank cells in the column.

Cory Larsen

Excellent! That worked very well - could I add another step? We would like "Ready to ship", "shipped", and "Complete" combined to represent % of project complete divided by total cells with any value in them - ?

Cory Larsen

I think I figured it out - does this look right?

=(COUNTIFS([Line Status]:[Line Status], "Ready To ship") + COUNTIFS([Line Status]:[Line Status], "Complete") + COUNTIFS([Line Status]:[Line Status], "Shipped")) / COUNTIF([Line Status]:[Line Status], <>"")

Genevieve P.

Hey @Cory Larsen

Just jumping in here to say that looks great! Well-done 🙂