Thread: average when one or more cells are in blank
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default average when one or more cells are in blank
=average(b4:b34)

It will disregard blank cells.

Regards,
Fred.

"art" wrote in message
...
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