The main problem was, that source cells were not empty/blank, at least some of them contained spaces.
For e.g. column BH the working formula (without editing all cells containing only space strings) will be
Code:
=IF(COUNT(I4:Q4)>=5, (SUM(I4,J4,L4,N4,O4)+(IF(ISBLANK(K4),0,(5-SUM(K4))))+(IF(ISBLANK(M4),0,(5-SUM(M4))))+(IF(ISBLANK(P4),0,(5-SUM(P4))))+(IF(ISBLANK(Q4),0,(5-SUM(Q4)))))/COUNT(I4:Q4), "")
Oops! This leaves wrong answer for ISBLANK() checks! I post right formula after couple of minutes!
Code:
=IF(COUNT(I4:Q4)>=5, (SUM(I4,J4,L4,N4,O4)+(IF(TRIM(K4)="",0,(5-K4)))+(IF(TRIM(M4)="",0,(5-M4)))+(IF(TRIM(P4)="",0,(5-P4)))+(IF(TRIM(Q4)="",0,(5-Q4))))/COUNT(I4:Q4), "")