Calculate percentage of completion for tasks

Hi Guys,


I have a question:

I am trying to measure Key Performance Indicators for a business and am hoping to have them calculate the percentage of time tasks were done. So what i am doing is putting a 0 where the task wasn't done and 1 when the task was done. I will leave blank if a score was not applicable in this case. So is there way I can get the percentage to tally up automatically while taking into account the fact that if I lead a space blank and the task wasn't applicable.

Please Login or Register  to view this content.

So for task A the kpi score is 2/6 = 33% and task B the KPI score is 7/7 = 100%

So I I have =Sum(K5:Q5)/What?

How do I get excel to automatically calculate how many boxes contain a data point? I was trying to using IF statements but got a bit lost and need help

Welcome to the Forum Merchant100!

=SUM(K5:Q5)/COUNT(K5:Q5)

I have fixed the spacing on your example and updated your title to something more meaningful.