IF Statement returns 0 instead of blank

[nenandi]

How to solve this IF statement returns 0 instead of blank
=IF(SUM(D21:D27)>0,1,IF(OR(D21=0,D22=0,D23=0,D24=0,D25=0,D26=0,D27=0),0,IF(OR(D21="",D22="",D23="",D24="",D25="",D26="",D27=""),"")))
I want to show me empty cell for further average calculation.

 

[nenandi]

According to your description, then @FormR formula in Post # 2 should work for you.

yep

 

[nenandi]

What if some are blank and some are zero? is that possible?

it is not possible if it fill all cell will be filed other just skip this column.