Dollar amount dependent on date

[Guest]

Hi, I have a column of $ amounts and corresponding dates
in another column.

Date Amount
1/1/04 $100.00
1/15/04 $100.00
1/31/04 $100.00


On a seperate page I have

Sum for Month
January $200.00
February $100.00

If the date occurs up to and including the 15th of the
month I want to be able to add that $ amount into a cell
which would contain the entire sum for the month. If the
date occurs after the 15th it would need to be added to
the sum of the next month.

 

[Don Guillett]

something like this?
=sumproduct((month(a2:a200)=1)*(day(a2:a200)<=15)*b2:b200)

 

[Frank Kabel]

Hi
try for February:
=SUMPRODUCT(--('sheet1'!A1:A100>DATE(2004,1,15)),--('sheet1'!A1:A100<=D
ATE(2004,2,15)),'sheet1'!B1.B100)

 

[Guest]

Worked! Thanks

-----Original Message-----
Hi
try for February:
=SUMPRODUCT(--('sheet1'!A1:A100>DATE(2004,1,15)),-- ('sheet1'!A1:A100<=D
ATE(2004,2,15)),'sheet1'!B1.B100)

--
Regards
Frank Kabel
Frankfurt, Germany




.

 

[Guest]

Worked! Thanks

-----Original Message-----
Hi
try for February:
=SUMPRODUCT(--('sheet1'!A1:A100>DATE(2004,1,15)),-- ('sheet1'!A1:A100<=D
ATE(2004,2,15)),'sheet1'!B1.B100)

--
Regards
Frank Kabel
Frankfurt, Germany




.