average when one or more cells are in blank

[art]

I have to average from B4 to B34 column but some of the cells are in blank
Which formula should I used?

 

[Fred Smith]

=average(b4:b34)

It will disregard blank cells.

Regards,
Fred.

 

[Teethless mama]

=AVERAGE(B4:B34)