+ Reply to Thread
Results 1 to 5 of 5

Formula doesn't work only for one particular entry??? Confused

  1. #1
    Forum Contributor
    Join Date
    12-06-2013
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2016
    Posts
    605

    Formula doesn't work only for one particular entry??? Confused


    Hi Experts,
    I have attached here an excel work sheet where the formula doesn't work for some particular entry in 'Monthly Expenses Summary' sheet.
    I have highlighted this in RED. A value of 125000 should appear in the RED highlighted cell. Pls help.

    Thanks.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,110

    Re: Formula doesn't work only for one particular entry??? Confused

    The formula in H23 is only looking at rows 6:21 but you have data going down to row 23.

  3. #3
    Forum Contributor
    Join Date
    12-06-2013
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2016
    Posts
    605

    Re: Formula doesn't work only for one particular entry??? Confused

    Hi,
    I found the error. I have not updated the range..
    Sorry for my stupidity.

  4. #4
    Forum Contributor
    Join Date
    12-06-2013
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2016
    Posts
    605

    Re: Formula doesn't work only for one particular entry??? Confused

    Yes, I found the error. I was so stupid.

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,110

    Re: Formula doesn't work only for one particular entry??? Confused

    Glad to help & thanks for the feedback.
    As the Journal sheet has a table why not use structured references rather than addresses, that way it will always be looking at all the data.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula Doesn't Work
    By Gene Venzke in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-10-2013, 08:54 PM
  2. Replies: 1
    Last Post: 10-03-2012, 10:32 PM
  3. [SOLVED] Macro executes but not giving results :confused::confused::confused:
    By Ganesh7299 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2012, 10:49 AM
  4. formula doesn't work in name
    By foxguy in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-29-2011, 10:29 AM
  5. Auto fill doesn’t work, but trying to avoid manual entry of rows.
    By Sal1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-01-2010, 05:55 PM
  6. [SOLVED] FORMULA DOESN'T WORK
    By Loyd in forum Excel General
    Replies: 4
    Last Post: 03-30-2006, 01:20 PM
  7. Why doesn't this formula work
    By greengrass in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2005, 10:57 PM

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