Ignoring #DIV/0!

  • Thread starter Thread starter tillyosu
  • Start date Start date
T

tillyosu

How can I make excel ignore a #DIV/0! error when averaging a range o
cells??
 
Something like

=IF(B1=0,"",A1/B1)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
tillyosu wrote...
How can I make excel ignore a #DIV/0! error when averaging a range of
cells???
Click to expand...

Meaning something like AVERAGE(B5:D10) returns #DIV/0! ? That only
happens when there are no numeric values in the range or when one or
more of the cells in the range evaluates to #DIV/0! . You probably
shouldn't ignore the latter.

As for the former, it depends on what you want to show, but the generic
approach is

=IF(COUNT(B5:D10),AVERAGE(B5:D10),"")
 
You must log in or register to reply here.

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

How do I average a group of cells and ignore a #div/0! error? 8
how to average a range of cells and ignore #div/0! answer 4
#div/0 error 2
#DIV/0! error 1
Find Average w/ #DIV/0! in Cell 5
How to avoid #DIV/0, I AM USING =AVERAGE(IF(F30:F69=3,O30:O69,"0") 5
How do I ignore blank cells while averaging the solutions of equat 2
AVERAGE around a #Div/0 error? 2

Back
Top