Results 1 to 2 of 2

#DIV/0! error where there was none before

Threaded View

  1. #1
    Registered User
    Join Date
    04-03-2008
    Posts
    14

    #DIV/0! error where there was none before

    A worksheet of mine is returning tons of #DIV/0! errors where it should not. It was fine for weeks before, and today I just noticed it is wigging out, even though I can't think of anything I have changed on the sheet it pulls data from. I know I definitely havent changed anything in the formulas.

    The sheet pulls data from another sheet in the excel file:

    =SUM(IF('NBA Line Watching'!M31:'NBA Line Watching'!M9999="ATL",IF('NBA Line Watching'!O31:'NBA Line Watching'!O9999="W-b",1,0)))+SUM(IF('NBA Line Watching'!M31:'NBA Line Watching'!M9999="ATL",IF('NBA Line Watching'!O31:'NBA Line Watching'!O9999="W-bi",1,0)))+SUM(IF('NBA Line Watching'!M31:'NBA Line Watching'!M9999="ATL",IF('NBA Line Watching'!O31:'NBA Line Watching'!O9999="W",1,0)))+SUM(IF('NBA Line Watching'!M31:'NBA Line Watching'!M9999="ATL",IF('NBA Line Watching'!O31:'NBA Line Watching'!O9999="W-i",1,0)))

    The other sheet is called NBA Line Watching.
    What I'm doing here is going through and looking for every game played by ATL (column M) in which a W-b, W-bi, W, or W-i appears in column O. Rows are from 31 to 9999.
    I started getting DIV/0 on one part of this sheet where I use these formulas, but on the other part of the sheet with very similar formulas I have NO problems. Here is that formula:

    =SUM(IF('NBA Line Watching'!K31:'NBA Line Watching'!K9999="ATL",IF('NBA Line Watching'!L31:'NBA Line Watching'!L9999="W-b",1,0)))+SUM(IF('NBA Line Watching'!K31:'NBA Line Watching'!K9999="ATL",IF('NBA Line Watching'!L31:'NBA Line Watching'!L9999="W-bi",1,0)))

    Here I'm pulling ATL from Column K when there is a W-b or W-bi in column L. Working fine.

    None of the referenced cells in the troubled formula have been moved or altered or anything. This stuff was literally working fine one day (for a long time) and broken the next. I tried hitting F2 and then CTRL SH ENTER and no luck.

    Any help is appreciated, thanks!
    Last edited by DUAL; 04-03-2008 at 05:08 AM.

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