L
Lisa
Hello
I need to average a range of cells where there are blanks and zero’s and
both have meaning. I’ve used a generic formula =average(b21:b27) which works
with the exception of when there is a range of seven days of no data (looks
blank). The desired result would have the result be blank but I receive
#DIV/O for an error. Can you please help?
I need to average a range of cells where there are blanks and zero’s and
both have meaning. I’ve used a generic formula =average(b21:b27) which works
with the exception of when there is a range of seven days of no data (looks
blank). The desired result would have the result be blank but I receive
#DIV/O for an error. Can you please help?