+ Reply to Thread
Results 1 to 8 of 8

Sum cells from data based on dates?

  1. #1
    Registered User
    Join Date
    11-09-2010
    Location
    Montana
    MS-Off Ver
    Excel 2007
    Posts
    7

    Sum cells from data based on dates?

    Hi,

    Haven't posted in a long long time! I am requesting some help, to what I feel will be close to the finishing touches on my pilot logbook excel.

    I'm hoping to somehow to a date look back, from today(), looking back 30, 60, 90, 120, 180, and 365 days. Now, I have all the dates of respective flights in Column A. In Column F I have the total hours for the respective date. I'd somehow like it to basically look at today's date, compare to Column A, figure up to a date X amount of days prior, and add up that many cells from Column F.

    Is this even remotely possible? It is helpful as we pilots have to have look backs on all those days when doing job apps and such, and this would simplify a TON for me!

    Any help would be greatly appreciated! I already owe the current state of my logbook to you wonderful people!

    Thanks in advance!
    Last edited by pd400; 11-09-2010 at 07:19 AM.

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Sum cells from data based on dates?

    Haven't posted in a long long time!
    You've just registered today. What do you mean?

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!

  3. #3
    Registered User
    Join Date
    11-09-2010
    Location
    Montana
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Sum cells from data based on dates?

    Quote Originally Posted by teylyn View Post
    You've just registered today. What do you mean?

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!
    I was recently banned under another name, due to mis-communication. I have since smoothed it over with mod royUK.

    I will try to make a dummy one and attach it here soon. I am hoping this complex issue (or simple maybe even) can be figured out

    Thanks for the post!

  4. #4
    Registered User
    Join Date
    11-09-2010
    Location
    Montana
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Sum cells from data based on dates?

    Edit: Removed attachments
    Last edited by pd400; 11-09-2010 at 07:44 AM.

  5. #5
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Sum cells from data based on dates?

    Actually, seeing your conduct under your banned user persona, I'm not very tempted to help you. Sorry.

  6. #6
    Registered User
    Join Date
    11-09-2010
    Location
    Montana
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Sum cells from data based on dates?

    Quote Originally Posted by teylyn View Post
    Actually, seeing your conduct under your banned user persona, I'm not very tempted to help you. Sorry.
    Hi teylyn,

    I'm sorry to hear that. Fair enough. I have since smoothed it over with royUK, as it was a misunderstanding for the most part. I have since apologized.

    I understand your reluctance. Thanks for the help so far.

    I truly hope that someone helps me with it.

  7. #7
    Registered User
    Join Date
    11-09-2010
    Location
    Montana
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Sum cells from data based on dates?

    I see your little thing on Cross-posting. I was unaware of this, but understand. So in hopes not making people made, here is another post I am asking for help in:

    Cross post
    Last edited by pd400; 11-09-2010 at 06:45 AM. Reason: better link

  8. #8
    Registered User
    Join Date
    11-09-2010
    Location
    Montana
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Sum cells from data based on dates?

    Hi,

    Thanks for the help on this post! It was solved here!

    All the best

+ 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