Need helpwith a formula

Copper Contributor

Hello, i have a simple qeustion for probably most but i need help

 

I am trying to create a spreadsheet to get an average score. Typically i would create a formula like 

=sum(b3:f8)/(5) 

This would give me the average number if every cell was filled out. However in this case every cell may not get filled out and i dont know how to write that.

 

Hope i explained this well enough!

1 Reply
=AVERAGE(B3:F8)