Find date between 2 dates and place corresponding values of orginal date if between 2 date

Hi,

Looking for bit of help on the detail below, I want to enter in a date in column A e.g. 4 08/01/2014 and the correspond amount in column B €88.11 and if a date falls between the start date and end date of any of the date below e.g. 4 02/01/2014 - 08/01/2014 = the corresponding amount will be place in the fuel spend also if two date entered within same date range they should be added for a cumulative total.

This is the formula I have so far but will only work for first entery.

=IF(AND('Total Month'!A$4:A$30>=B4,'Total Month'!A$4:A$30<=D4),(VLOOKUP('Total Month'!A4,'Total Month'!$A$4:$B$44,2,))

Id be greatful of any help.


Total Month
A B
Date Amount


4 08/01/2014 €88.11
5 02/02/2014 €55.00
6 12/02/2014 €65.00
7 07/01/2014 €100.00

B D
Start Date End Date Fuel Spend

3 26/12/2013 - 01/01/2014 = € 0.00
4 02/01/2014 - 08/01/2014 = € 88.11
5 09/01/2014 - 15/01/2014 = FALSE
6 16/01/2014 - 22/01/2014 = FALSE
7 23/01/2014 - 29/01/2014 = FALSE
8 30/01/2014 - 05/02/2014 = FALSE
9 06/02/2014 - 12/02/2014 = FALSE
10 13/02/2014 - 19/02/2014 = FALSE

Welcome to the forum.
Could you attached sample spreadsheet with expected results?



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Fuel Spend 2014.xlsx

Thank alvin

When I enter a date and an amount in A and B column in the total month sheet, I would like the amount on that date/dates to be copied into the sheet fuel spend dates,

If the date in total month sheet is between two dates on the fuel spend date sheet the amount should be entered in the fuel spend column F and if two dates/amounts from total month fall in that range the amount should be added together given a total fuel spend between those dates.

hope that makes sense

Cheer Paul

Fuel Spend 2014_new.xlsx

Try this in row 3 and copy it down

Formula:

Please Login or Register  to view this content.

Hi Paul, you can utilize your existing names (so that you'll have no worries in future on expanding rows) and do something like this in F3, then copy down till end of the rows.

Formula:

Please Login or Register  to view this content.

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Hi Paul, thanks for the repu
You're most welcome.



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin