+ Reply to Thread
Results 1 to 8 of 8

Formula issue in spreadsheet every attempt causes wrong value

  1. #1
    Registered User
    Join Date
    03-11-2016
    Location
    UK
    MS-Off Ver
    2010
    Posts
    3

    Question Formula issue in spreadsheet every attempt causes wrong value

    Hi Guys,

    Wonder if any of you can help me out here.

    Ive only ever built 1 excel file with formulas before and that wasnt as complex as this one im working on now.

    Ive got to a point that i have tried and tried and tried to get the formula to work but i cant seem to get it right, ive attached the file in question but basically i cant figure what formula i need for this file.

    Values inputted into column D should expire after 30 days so value in 1 should be removed at 30, value in 2 should be removed at 31 etc but also the value in column E should reflect that and also reflect the addition of any other value placed in column D all being under the same rule of expiring at 30 days.

    Ive tried =E56-D1+D57 In the column and row where the value expires and ive tried dragging (by the lower right corner of the cell) but all that happens is the value "1" appears in ALL cells in that column.

    Im stuck

    Please help
    Attached Files Attached Files
    Last edited by danelliott; 03-11-2016 at 07:39 PM. Reason: Changing Title Of Thread
    clickintensitypro.com
    tlkuk.co.uk

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,546

    Re: New to excel and now got myself stuck

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    03-11-2016
    Location
    UK
    MS-Off Ver
    2010
    Posts
    3

    Re: New to excel and now got myself stuck

    I Apologize, How do i change the Title Please?

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.54 for Mac (home)
    Posts
    7,372

    Re: New to excel and now got myself stuck

    I believe you can do it using "thread tools" drop down at the top of the post.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  5. #5
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.54 for Mac (home)
    Posts
    7,372

    Re: New to excel and now got myself stuck

    Here's the instructions...
    To edit or delete your posts, click the Edit Post button by the particular post. If your post was the first in the thread, then deleting it may remove the entire thread.

    Once you've made your modifications, a note may appear to inform other users that you have edited your post.

    If the edit time and date appear as a link you can click on this to see the differences between the original and edited versions, or between edits if there have been multiple edits.

  6. #6
    Registered User
    Join Date
    03-11-2016
    Location
    UK
    MS-Off Ver
    2010
    Posts
    3

    Re: New to excel and now got myself stuck

    Thank you Sambo Kid

  7. #7
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.54 for Mac (home)
    Posts
    7,372

    Re: Formula issue in spreadsheet every attempt causes wrong value

    First, I'm not sure your post title still meets the forum rules but I'll try to help you with some advice.
    I'm not sure I understand from your posted question what it is you are trying to achieve.
    Your spreadsheet is somewhat busy with a lot of information but no way to interpret what results you want to achieve.
    You're referring to column D and the values expiring after 30 days then 31 etc. Which values in which cells would this refer to? Which value is the one that the others refer to? Which cells downstream from that cell will refer to it. It appears that cell D3 is a key cell and a lot of other cells use it as a reference.
    Try to limit the amount of info in your spreadsheet and show what you want, what or which cell is set and which cells should change and how they should change - what it is you want in those cells.

  8. #8
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    12,928

    Re: Formula issue in spreadsheet every attempt causes wrong value

    Having the received the go ahead from Ben I'll post a solution.
    Paste the following formula in E7 and double click to get it to copy down:
    Please Login or Register  to view this content.
    Let me know if you have any questions.
    PS. If this solution resolves your issue then for those who may come looking for a similar solution in the future, I would say a title more like "Summing a specific range" would be appropriate.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Excel gets stuck on a cell
    By Chogreshi in forum Excel General
    Replies: 13
    Last Post: 10-23-2014, 11:33 AM
  2. Stuck at work and stuck on a count function
    By gregfetzer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-24-2012, 12:47 AM
  3. [SOLVED] for next gets stuck - excel 2003
    By Alexander_Golinsky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-27-2012, 08:16 AM
  4. Mouse is stuck in excel?
    By ihawk in forum Excel General
    Replies: 3
    Last Post: 03-25-2009, 07:50 AM
  5. Stuck Excel macro
    By RCH in forum Excel General
    Replies: 1
    Last Post: 02-25-2007, 11:23 PM
  6. [SOLVED] Stuck Button effect in Excel
    By JohnB in forum Excel General
    Replies: 1
    Last Post: 02-13-2006, 11:40 AM
  7. [SOLVED] Excel Concatenate - Please help, really stuck
    By Dip in forum Excel General
    Replies: 2
    Last Post: 12-19-2005, 02:35 AM
  8. VBA Query to Excel, Stuck.
    By Hopest in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-07-2005, 09:40 AM

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