sum between dates

[Plasim]

Hi, as seen below, I have two columns, one with dates (9-Feb-05), and one with dollar amounts($1.00). Where you see the question mark, I am trying to calculate the total dollars between the "from" and "to" dates using the data in the 2 columns. Does anyone know a formula for this?

Thanks


FROM TO TOTAL
Week 1 3-Mar-05 25-Feb-05 ?
Week 2 24-Feb-05 18-Feb-05 ?
Week 3 17-Feb-05 11-Feb-05 ?
Week 4 10-Feb-05 4-Feb-05 ?

Data

9-Feb-05 $1.00
12-Feb-05 $2.00
1-Mar-05 $3.00
20-Feb-05 $5.00
5-Feb-05 $4.00

[Bob Phillips]

=sumproduct(--($A$1:A$100>=to_date_cell),--($A$1:$A$100<=from_date_cell),$B$
1:$B$100)

replace the to_date_cell and from_date_cell by the actual cell references.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Plasim" <[email protected]> wrote in
message news:[email protected]...
>
> Hi, as seen below, I have two columns, one with dates (9-Feb-05), and
> one with dollar amounts($1.00). Where you see the question mark, I am
> trying to calculate the total dollars between the "from" and "to"
> dates using the data in the 2 columns. Does anyone know a formula for
> this?
>
> Thanks
>
>
> FROM TO TOTAL
> Week 1 3-Mar-05 25-Feb-05 ?
> Week 2 24-Feb-05 18-Feb-05 ?
> Week 3 17-Feb-05 11-Feb-05 ?
> Week 4 10-Feb-05 4-Feb-05 ?
>
> Data
>
> 9-Feb-05 $1.00
> 12-Feb-05 $2.00
> 1-Mar-05 $3.00
> 20-Feb-05 $5.00
> 5-Feb-05 $4.00
>
>
> --
> Plasim
> ------------------------------------------------------------------------
> Plasim's Profile:
http://www.excelforum.com/member.php...o&userid=28909
> View this thread: http://www.excelforum.com/showthread...hreadid=486568
>

[Plasim]

Thanks Bob, works great!!

Plasim