# Sum cells from data based on dates?

1. ## 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!

2. ## 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. ## Re: Sum cells from data based on dates?

Originally Posted by teylyn
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. ## Re: Sum cells from data based on dates?

Edit: Removed attachments

6. ## Re: Sum cells from data based on dates?

Originally Posted by teylyn
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. ## 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

8. ## Re: Sum cells from data based on dates?

Hi,

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

All the best

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

#### 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