% complete in a row

dave.mcpherson56751

Hi, i am looking for some help.

I have a project which has 360 locations, resulting in 360 rows. i have 8 status columns in each row. is there a formula that will replicate a % by counting each status column that is complete and making that =12.5 .

So for example all 8 status are complete this = 100, 6 status complete would = 75.

hopefully some help is out there?

thank you

Dave

Paul Newcome

Give this a try...

 

=COUNTIFS([Status Column 1]:[Status Column 8], "Complete") * 12.5 + "%"

 

or

 

=COUNTIFS([Status Column 1]:[Status Column 8], "Complete") * .125

 

and then format the column as a percentage.

 

You'll just need to change the column names to whatever you're using along with the text "Complete".

 

Remember... when using "Text" to denote a specific text, it is case sensitive. So if your status is Complete and you have "complete" in your formula (or even "Completed"), it won't give you the results you're looking for.

dave.mcpherson56751

Hi Paul,

 

That has worked a treat, thank you so much for taking the time to help.

Really appreciated

Dave