Thread: average when one or more cells are in blank
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default average when one or more cells are in blank
=AVERAGE(B4:B34)

"art" wrote:

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