+ Reply to Thread
Results 1 to 3 of 3

#DIV/0 error

  1. #1
    Registered User
    Join Date
    09-19-2014
    Location
    NC
    MS-Off Ver
    2007
    Posts
    7

    #DIV/0 error

    This formula is working great with 1 exception. If the data in C2:C366 is blank, it causes a #DIV/0 error. What do I add to have the result be "" if C2:C366 is blank for the value "NOV"

    Thanks



    =SUMIF('Data Daily'!$A$2:$A$366,"NOV",'Data Daily'!$C$2:$C$366)/((COUNTIF('Data Daily'!$A$2:$A$366,"NOV")-COUNTIFS('Data Daily'!$A$2:$A$366,"NOV",

  2. #2
    Registered User
    Join Date
    09-17-2014
    Location
    New York
    MS-Off Ver
    2013
    Posts
    20

    Re: #DIV/0 error

    I was putting the form as a if statement, my apologies
    Last edited by New2vbabutloveit; 09-19-2014 at 10:32 PM.

  3. #3
    Registered User
    Join Date
    09-17-2014
    Location
    New York
    MS-Off Ver
    2013
    Posts
    20

    Re: #DIV/0 error

    sorry correct is
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Run-tim error -2147467259(80004005): Automation error Unspecidied error
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2014, 12:12 PM
  2. Excel macro (compile error. syntax error.) error
    By salar_younis in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-06-2014, 06:11 AM
  3. Error "run-time Error '1004': General Odbc Error
    By D4WNO77 in forum Access Tables & Databases
    Replies: 2
    Last Post: 07-16-2012, 09:55 AM
  4. Error 75 File/Path access error, sometimes Error 1004
    By smokebreak in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-16-2011, 02:35 PM
  5. Error Handling - On Error GoTo doesn't trap error successfully
    By David in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-16-2006, 02:10 PM

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