J
Jman
First of all i want to say my initial problem was solved
by T. Valko. But i want to add something else to this .. Lets say in
Sheet1 D1 to D3000 i also have numbers that i want summed up if the dates
match up. but only to the ones that match up for example
Taken from bottom example when C1 3/10/08 shows up i, i want D1 containing
a number ex "132" to be added to the next date that matches up which would be
C3 3/04/08. (D3,"345")
In sheet 1 i have
C1 to C30000 "dates.
C1 3/10/08 D1 "132"
C2 4/30/08 D2 should not be counted since it does not match up with dates
below
C3 3/04/08 D3 "345"
C4 1/03/05
C5 3/16/08
ect
In sheet 2
I have
A1: this date 3/1/08
A2: this date 3/15/08
..................................
I want a formula in C5 that will look into sheet one and see if any dates i
i put in A:1 to A3000 falls on or in between the dates in sheet 2. "3/1/08"
and " 3/15/08"
and if so.. SUM THE "D" Row matching up with the dates as shown above.
.........................................................
From the example above the answer that i am lookin for should be 477 since
there are only two dates that fall in between and they are ,3/10/08 ,D1"132 +
3/04/08 D2 345 equals 477
by T. Valko. But i want to add something else to this .. Lets say in
Sheet1 D1 to D3000 i also have numbers that i want summed up if the dates
match up. but only to the ones that match up for example
Taken from bottom example when C1 3/10/08 shows up i, i want D1 containing
a number ex "132" to be added to the next date that matches up which would be
C3 3/04/08. (D3,"345")
In sheet 1 i have
C1 to C30000 "dates.
C1 3/10/08 D1 "132"
C2 4/30/08 D2 should not be counted since it does not match up with dates
below
C3 3/04/08 D3 "345"
C4 1/03/05
C5 3/16/08
ect
In sheet 2
I have
A1: this date 3/1/08
A2: this date 3/15/08
..................................
I want a formula in C5 that will look into sheet one and see if any dates i
i put in A:1 to A3000 falls on or in between the dates in sheet 2. "3/1/08"
and " 3/15/08"
and if so.. SUM THE "D" Row matching up with the dates as shown above.
.........................................................
From the example above the answer that i am lookin for should be 477 since
there are only two dates that fall in between and they are ,3/10/08 ,D1"132 +
3/04/08 D2 345 equals 477
3000)-SUMIF(Sheet1!C1:C3000,">"&A2,Sheet1!D1