"Formula omits adjacent cells" Error.

Discussion in 'Microsoft Excel Worksheet Functions' started by John Prendergast, Feb 7, 2004.

  1. I have started using Excel 2002 on a XP Pro system. I use
    excel to chart stock values. With this ver of excel, the
    range of cells that are refereneing data from other cell
    ranges are taged with this error. An example would be in
    column "e" =sum(a10:a14)/15. Why does this happen, and what
    is the solution. I have used excel 97 for a long time
    without this error. The data result is correct, but why the
    error?


    Thanks.
     
    John Prendergast, Feb 7, 2004
    #1
    1. Advertisements

  2. John Prendergast

    Frank Kabel Guest

    Hi John
    nothing to worry about. Excel is just getting 'smarter'. As the error
    message stated there are probably values in A9 and/or A16. As Excel
    recognizes this and is assuming a SUM function would include theses
    cells it tagges your formula.

    If you're annoyed by this feature, copen the listbox attached to this
    tag symbol, choose 'Options' and disable the error messages of your
    choice

    Frank

    John Prendergast wrote:
    > I have started using Excel 2002 on a XP Pro system. I use
    > excel to chart stock values. With this ver of excel, the
    > range of cells that are refereneing data from other cell
    > ranges are taged with this error. An example would be in
    > column "e" =sum(a10:a14)/15. Why does this happen, and what
    > is the solution. I have used excel 97 for a long time
    > without this error. The data result is correct, but why the
    > error?
    >
    >
    > Thanks.
     
    Frank Kabel, Feb 7, 2004
    #2
    1. Advertisements

  3. John Prendergast

    Guest Guest


    >-----Original Message-----
    >Hi John
    >nothing to worry about. Excel is just getting 'smarter'.

    As the error
    >message stated there are probably values in A9 and/or A16.

    As Excel
    >recognizes this and is assuming a SUM function would

    include theses
    >cells it tagges your formula.
    >
    >If you're annoyed by this feature, copen the listbox

    attached to this
    >tag symbol, choose 'Options' and disable the error

    messages of your
    >choice
    >
    >Frank
    >
    >John Prendergast wrote:
    >> I have started using Excel 2002 on a XP Pro system. I use
    >> excel to chart stock values. With this ver of excel, the
    >> range of cells that are refereneing data from other cell
    >> ranges are taged with this error. An example would be in
    >> column "e" =sum(a10:a14)/15. Why does this happen, and what
    >> is the solution. I have used excel 97 for a long time
    >> without this error. The data result is correct, but why the
    >> error?
    >>
    >>
    >> Thanks.

    >
    >
    >.
    >Thank you, I was going to do this, but I wanted to make

    sure there wasn't more serious problem.
     
    Guest, Feb 7, 2004
    #3
  4. John Prendergast

    Gord Dibben Guest

    anon

    You can prevent the flags from showing up if you choose or pick which type of
    error you want to flag.

    Tools>Options>Error Checking.

    Gord Dibben Excel MVP



    On Sat, 7 Feb 2004 07:32:26 -0800, <>
    wrote:

    >>Thank you, I was going to do this, but I wanted to make

    >sure there wasn't more serious problem.
     
    Gord Dibben, Feb 7, 2004
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. hglamy

    Change #REF-Error into #NV-Error for array-formula

    hglamy, Nov 25, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    351
    hglamy
    Nov 25, 2003
  2. Guest

    How do I replace "#N/A" error, to continue my formula w/o error?

    Guest, Feb 20, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    367
    Guest
    Feb 20, 2006
  3. Augabog

    How to obtain both std dev and std error mean in each y error bar

    Augabog, Apr 16, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    414
    Augabog
    Apr 16, 2006
  4. Guest

    How do I solve the error this #VALUE! error

    Guest, Apr 27, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    242
    Guest
    Apr 27, 2006
  5. S Davis

    Counting instances of found text (Excel error? Or user error?)

    S Davis, Sep 12, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    407
    S Davis
    Sep 12, 2006
  6. Guest

    Formula Omits Adjacent Cells

    Guest, Nov 6, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    7
    Views:
    1,998
    MartinW
    Nov 6, 2007
  7. Walter Briscoe

    Spurious Formula Omits Adjacent Cells

    Walter Briscoe, May 18, 2012, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    644
    Vacuum Sealed
    May 19, 2012
  8. Walter Briscoe

    Spurious Formula Omits Adjacent Cells

    Walter Briscoe, May 18, 2012, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    2,305
    Walter Briscoe
    May 19, 2012
Loading...