Formula to count all cells with a date and provide a percentage.

[RKS2nd]

I am tracking completion of a task across 40+ tasks, looking for a percentage of tasks completed. Previously, I looked for a "x", we have been asked to change to entering the date task was completed. My formulas is below.

=SUM(IF(N4="x",1,0),IF(N5="x",1,0),IF(N6="x",1,0),IF(N7="x",1,0),IF(N8="x",1,0),IF(N9="x",1,0),IF(N10="x",1,0),IF(N11="x",1,0),IF(N12="x",1,0),IF(N13="x",1,0),IF(N14="x",1,0),IF(N15="x",1,0),IF(N16="x",1,0),IF(N17="x",1,0),IF(N18="x",1,0),IF(N19="x",1,0),IF(N20="x",1,0),IF(N21="x",1,0),IF(N22="x",1,0),IF(N23="x",1,0),IF(N24="x",1,0),IF(N25="x",1,0),IF(N26="x",1,0),IF(N27="x",1,0),IF(N28="x",1,0),IF(N29="x",1,0),IF(N30="x",1,0),IF(N31="x",1,0),IF(N32="x",1,0),IF(N33="x",1,0),IF(N34="x",1,0),IF(N35="x",1,0),IF(N36="x",1,0),IF(N37="x",1,0),IF(N38="x",1,0),IF(N39="x",1,0),IF(N40="x",1,0),IF(N41="x",1,0),IF(N42="x",1,0),IF(N43="x",1,0),IF(N44="x",1,0),IF(N45="x",1,0),IF(N46="x",1,0),IF(N47="x",1,0))/44)

Thanks for the assist. I d not know VBA.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Fluff]

How about

=COUNTIFS(N4:N47,"<>")/44

 

[RKS2nd]

How about

=COUNTIFS(N4:N47,"<>")/44

Thank you. That works perfectly.

 

[Fluff]

You're welcome & thanks for the feedback.
Thanks also for updating your profile.