Results 1 to 4 of 4

Bug in Excel 2003 or am I missing something here!?

Threaded View

  1. #1
    Registered User
    Join Date
    01-13-2012
    Location
    New Hampshire
    MS-Off Ver
    Excel 2003
    Posts
    6

    Bug in Excel 2003 or am I missing something here!?

    I have found something strange that is screwing up my spreadsheet and I just don't get it.... I am beginning to think it is a bug but perhpas not. Anyone know what it up here?!

    I have copied this formula: =COUNTIF(IF(($A$2:$A$9>=$D$1)*($A$2:$A$9<=$D$2),$B$2:$B$9),"<=50") in to numerous cells (just to test it) and it only works in the cells that are in the same row as the data.

    To simplify it, I have two columns of data with 8 data points (located in rows 2 through 9):

    Date DaystoProcess
    5/11/11 48
    6/13/11 16
    5/19/11 50
    5/20/11 52
    5/23/11 49
    6/2/11 40
    5/23/11 52
    5/26/11 70


    Then I have a start date and end date in two other cells (D1 and D2).
    All the cells are referenced with dollar sign ("$") so there shouldn't be any issues with referencing the wrong cells.

    If I copy this formula into any cell located in rows 2 through 9 it works. If it is referenced in any other cells then it results in a #VALUE!.


    Very puzzling!!!
    Or am I missing about something???
    ~Amy
    Last edited by amycclark; 01-20-2012 at 03:35 PM.

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