+ Reply to Thread
Results 1 to 3 of 3

#div/0!

  1. #1
    Registered User
    Join Date
    12-19-2007
    Posts
    4

    #div/0!

    I would like the error #DIV/0! not be visable for the following formula:
    =AVERAGE('Name 1'!C7,'Name 2'!C7,'Name 3'!C7,'Name 4'!C7,'Name 5'!C7,'Name 6'!C7,'Name 7'!C7,'Name 8'!C7,'Name 9'!C7,'Name 10'!C7,'Name 11'!C7,'Name 12'!C7,'Name 13'!C7,'Name 14'!C7,'Name 15'!C7)
    any and all help would be apperciated
    Thank you in Advance

  2. #2
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: Help with #DIV/0!

    Read forum rules!!!
    Last edited by contaminated; 10-21-2009 at 04:20 PM.
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, ?Born in USSR?
    Vusal M Dadashev

    Baku, Azerbaijan

  3. #3
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Help with #DIV/0!

    You could probably reduce that to

    =AVERAGE('Name 1:Name 15'!C7)

    and then to show a blank instead of error when there are no numbers..

    =IF(COUNT('Name 1:Name 15'!C7),AVERAGE('Name 1:Name 15'!C7),"")

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1