+ Reply to Thread
Results 1 to 7 of 7

[SOLVED] Adjacent cells omitted warning, why?

  1. #1
    Registered User
    Join Date
    09-11-2013
    Location
    Virginia Beach, USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    [SOLVED] Adjacent cells omitted warning, why?

    I’m getting the “Formula Omits Adjacent Cells” warning for the following formula on some cells but not others; however everything is working as it should. Why is excel complaining about omitted adjacent cells? It all looks good to me.

    Please Login or Register  to view this content.
    I have attached the file I am working on with the hidden rows unhidden so you can see whats going on. It is a weekly football picks spreadsheet that allows you to mark a 1 above the winning teams to get the number of incorrect picks in the left column. If no 1 marks the winning team then the above formula should count the blanks total for that team as 3 and simply assign a 0 incorrect picks for that game. If there is a 1, then the main if formula will tabulate a correct or incorrect pick accordingly.
    Attached Files Attached Files
    Last edited by simusphere; 09-11-2013 at 01:45 PM. Reason: This is now FIXED.

  2. #2
    Registered User
    Join Date
    06-27-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    94

    Re: Adjacent cells omitted warning, why?

    if you click on the error and select update formula to include cells, it will get rid of the error while keeping the correct value.
    You can also fix the first row and then drag down and it will clear the error mark out of the cells.
    Last edited by liz5818; 09-11-2013 at 12:31 PM.

  3. #3
    Registered User
    Join Date
    09-11-2013
    Location
    Virginia Beach, USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Adjacent cells omitted warning, why?

    That won't work because then it tries to add another cell in the calculation that I don't wan't. My formula is exactly what I want to do but excel doesn't like it for some buggy reason.
    Last edited by simusphere; 09-11-2013 at 01:29 PM.

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365/2016
    Posts
    8,450

    Re: Adjacent cells omitted warning, why?

    Go to File, Options, Formulas - In the Error Checking rules remove check from "Formulas which omits cells in a region"
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  5. #5
    Registered User
    Join Date
    09-11-2013
    Location
    Virginia Beach, USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Adjacent cells omitted warning, why?

    That did the trick AlKey, I'll mark this as fixed.

  6. #6
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365/2016
    Posts
    8,450

    Re: [SOLVED] Adjacent cells omitted warning, why?

    You're Welcome. Don't forget to thank those who helped by clicking on Add Reputation *

  7. #7
    Registered User
    Join Date
    05-16-2016
    Location
    Canyon Lake, Ca
    MS-Off Ver
    Various
    Posts
    1

    Re: Adjacent cells omitted warning, why?

    Thank you so much for your answer. I have been living with this annoyance for more years than I want to admit to :/) Like many things in life, we put up with small things that aren't so big to take the time to fix, but once we do we are overjoyed at the difference. I never thought that there would be anything that could prevent the problem you addressed and today for some reason, I looked it up and got your answer from 3 years ago, and you made my whole day ! ! ! For me I had to go to Tools to get to Options instead of File, Options, but that may be because I'm using a different or older version. Only wanted to point that out in case someone had a similar version as mine. Thank you so much again. In our busy society people could go about their own business and not be concerned about other people's questions. I have been grateful so many times for those that have cared and answered a question about something I was struggling with, and today I am very grateful for yours.

    Thank you again.

    Bigbird
    Mike

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    43,981

    Re: [SOLVED] Adjacent cells omitted warning, why?

    Big Bird, welcome to the forum and thank you for your feedback
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think some-1 helped you

    Regards
    Ford

+ 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