Returning a zero value in an average total

  • Thread starter chedd via OfficeKB.com
  • Start date
C

chedd via OfficeKB.com

Hi

I wish to return a zero value in the total cell when there is no data in the
column cells. At present it is showing #DIV/0! in the total cell. The
formula i am using at the moment is =AVERAGE(B6:B24). Please can help with
this query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

For-Next by a row Counting consecutive Zero in the column 4
I'm getting unwanted rounding to integer for an average of range of cells. 2
Excel Sumproduct 0
Code to set print range 1
Link page formula error problem 2
Substituting zero values in blank cells 5
macro on different reports CTRL+F in formula 2
Macro for displaying formula 3

Top