Code:
=if(count(ak4:aq4)>=4, (sum(ao4)+(if(trim(ak4)="",0,(5-ak4)))+(if(trim(al4)="",0,(5-al4)))+(if(trim(am4)="",0,(5-am4)))+(if(trim(an4)="",0,(5-an4)))+(if(trim(ap4)="",0,(5-ap4)))+(if(trim(aq4)="",0,(5-aq4))))/count(ak4:aq4), "")
Used Notepad to replace semicolons in formula with commas, and somehow forum converted the formula to lowercase! (In notepad were formulas upper case, I used Copy and Paste to transfer formula into post - and got all in lower case!)