Average range including blank cells: #DIV/0!

  • Thread starter Thread starter Areaka
  • Start date Start date
A

Areaka

I am trying to average a range of cells which sometimes includes blank
cells, which returns: #DIV/0! This happens when the entire range is
blank, but works fine when data is present. I would also like for it
to display "NO" instead of #DIV/0!

The formula I used was: =AVERAGE(B4:M4)

Any help is much appreciated!
 
Oh, thank you so much, I was working it and reworking it with IF
functions and not getting anywhere. I plugged yours in and
instantaneous!!! Thank you so much!!!!
 
Back
Top