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

Try this:

=SUMIF(Sheet1!C1:C3000,"="&A1,Sheet1!D1:D3000)-SUMIF(Sheet1!C1:C3000,""&A2,Sheet1!D1:D3000)


--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
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

Perfect.. Thanks again.

"T. Valko" wrote:

Try this:

=SUMIF(Sheet1!C1:C3000,"="&A1,Sheet1!D1:D3000)-SUMIF(Sheet1!C1:C3000,""&A2,Sheet1!D1:D3000)


--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
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

You're welcome!

--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
Perfect.. Thanks again.

"T. Valko" wrote:

Try this:

=SUMIF(Sheet1!C1:C3000,"="&A1,Sheet1!D1:D3000)-SUMIF(Sheet1!C1:C3000,""&A2,Sheet1!D1:D3000)


--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
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