+ Reply to Thread
Results 1 to 4 of 4

#div/0! error- but I'm not dividing!

  1. #1
    Registered User
    Join Date
    11-03-2010
    Location
    Tennessee
    MS-Off Ver
    Excel 2007
    Posts
    5

    #div/0! error- but I'm not dividing!

    I am currently receiving a #div/0! error in a sumif formula. However:

    -I am not dividing in my formula
    -The formula worked until today
    -The formula is working in other places in my spreadsheet (my formula sums a certain range for a variety of cities, and each 'if' is a different city) only one is not working
    -I have checked the entire range that I am trying to sum and do not find any other #div/0! errors

    I would appreciate any help anyone can provide. Thanks!

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

    Re: #div/0! error- but I'm not dividing!

    I would suspect that there are some #DIV/0! errors somewhere in the sum range, what formula are you using exactly?
    Audere est facere

  3. #3
    Registered User
    Join Date
    11-03-2010
    Location
    Tennessee
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: #div/0! error- but I'm not dividing!

    =SUMIF('2011_Budget_Detail'!$G$2:$G$5683, "Turlock, CA", '2011_Budget_Detail'!AN$2:AN$5683)

  4. #4
    Registered User
    Join Date
    11-03-2010
    Location
    Tennessee
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: #div/0! error- but I'm not dividing!

    You were right- I had the wrong filter on and just found the error. Thanks!!

+ 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